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 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 ...

Let's say you want to load data from an Excel 2003 (.xls) file into a database using SSIS: If you're running on a 64-bit machine, you'll get this:   Plus this error: [PASS Regional Mentor Spreadsheet [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the ...

Here's a couple cool SSIS Expressions for creating Package Version strings: Format: 1.0.0 (DT_STR,4,1252) @[System::VersionMajor] + ''.'' + (DT_STR,4,1252) @[System::VersionMinor] + ''.'' + (DT_STR,4,1252) @[System::VersionBuild] Format: 1.0.0.20100106 (DT_STR,4,1252) @[System::VersionMajor] + ''.'' + (DT_STR,4,1252) ...