THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS » SSIS Snack   (RSS)
  • SSIS Snack: Name Those Connections!

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 9, 2012
  • SSIS Snack: Data Flow Source Adapters

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 19, 2010
  • SSIS Snack: OLE DB Destination 1

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 1, 2010
  • 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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 19, 2010
  • SSIS Snack: SSIS, Excel, and a 64-bit OS

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2010
  • SSIS Snack: Package Version

    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) ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 6, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement