When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter a more concise identifier like the one shown here:   “Why should I enter this ...

Introduction Configuring a Source Adapter in a Data Flow Task couples (binds) the Data Flow to an external schema. This has implications for dynamic data loads. ''Why Can't I...?''   I'm often asked a question similar to the following: ''I have 17 flat files with different schemas that I want to load to the same destination database ...

Introduction SSIS Data Viewers are handy - very handy. I use them so much the Data Viewer link on my Data Flow Path context menu is showing signs of wear. I click on it that much. Using the Grid Data Viewer I'm starting with the Data Flow I built for SSIS Snack: The Trash Destination Adapter. The green arrow between the ''Dummy Source'' ...

Introduction Our friends at Sqlis.com created a Data Flow Component I use an awful lot when building SSIS packages: the Trash Destination Adapter. Adding to the Toolbox  After downloading and installing the version you wish to use, right-click the SSIS toolbox and click Choose Items:   When the Choose Toolbox Items ...

Introduction An easy-to-overlook function in an OLE DB Source adapter is the Preview button. Dummy Data To tinker with the Preview button, let's first create some dummy data in a Data Flow Task. There are a couple ways to create dummy data in a Data Flow, one way is to use an OLE DB Source. Drag it onto the data flow canvas and open the ...

Introduction This SSIS Snack is a continuation of a couple previous SSIS Snacks: SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join (please see the clarification SSIS Snack: SSIS 2005 Lookup Transformations 101)  SSIS Snack: Configuring a Conditional Split SSIS Snack: Conditional Split Outputs ...

Introduction This SSIS Snack is a continuation of a couple previous SSIS Snacks: SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join (please see the clarification SSIS Snack: SSIS 2005 Lookup Transformations 101) and SSIS Snack: Configuring a Conditional Split. Landing Zone When you use a Conditional Split to ...

Introduction I got ahead of myself in a post entitled SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join and my friend Eric Wisdahl (Blog) called my out in the comments. A Good Test If you've not been warned previously, I'm an engineer. I learn an awful lot by testing - I sometimes refer to this as my ...

Introduction In this SSIS Snack, I continue with the package in the last SSIS Snack. The Data Flow Task in the package currently looks like this: Configure a Conditional Split Drag a Conditional Split Transformation onto the Data Flow canvas and connect the output of the Lookup (''Correlate'') to it. Open the editor, we're going to add ...

Introduction In SSIS 2005, the Lookup Transformation will fail if it does not find a matching record in the lookup table if configured with the default settings. Build the Data Flow Create a Data Flow Task and add an OLEDB Source. In the OLEDB Source Adapter, connect to AdventureWorks and use the following T-SQL statement to extract data from ...