Category Archives: SSIS

The more I work with the SSIS catalog the more I appreciate that it’s design is an improvement over the SSIS in SQL 2008. Were going to avoid the heavy explanation and just walk through creating the SSIS catalog, folders and assigning permission for your developers. This post is more… Read more »

We are looking at the Lookup Transformation in SSIS and we will try to clarify the Match and No Match options. The Lookup object allows you to “look” at the destination table and decide where to route records based on whether they are present or not present. Lookup Transformation The… Read more »