Browse by Tags

• Design Pattern
• Elegant Design
• Excel
• Incremental
• SSIS
• x64

• 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 Read More... Posted Thursday, February 09, 2012 8:00 AM by andyleonard | 13 Comments Filed under: SSIS, Elegant Design, SSIS Snack

• 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 Read More... Posted Friday, March 19, 2010 8:00 AM by andyleonard | 1 Comments Filed under: SSIS, SSIS Snack

• SSIS Snack: Grid Data Viewer

  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 Read More... Posted Monday, March 08, 2010 8:00 AM by andyleonard | 1 Comments Filed under: SSIS Snack

• SSIS Snack: The Trash Destination Adapter

  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 Read More... Posted Thursday, March 04, 2010 8:00 AM by andyleonard | 11 Comments Filed under: SSIS Snack

• SSIS Snack: Data Preview

  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, Read More... Posted Wednesday, March 03, 2010 8:00 AM by andyleonard | 0 Comments Filed under: SSIS Snack

• 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: Read More... Posted Monday, March 01, 2010 8:00 AM by andyleonard | 0 Comments Filed under: SSIS, SSIS Snack

• 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 Read More... Posted Friday, February 19, 2010 8:00 AM by andyleonard | 1 Comments Filed under: Incremental, SSIS, SSIS Snack

• SSIS Snack: SSIS 2005 Lookup Transformations 101

  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, Read More... Posted Tuesday, February 16, 2010 8:00 AM by andyleonard | 3 Comments Filed under: SSIS Snack

• SSIS Snack: Configuring a Conditional Split

  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 Read More... Posted Thursday, February 11, 2010 8:00 AM by andyleonard | 4 Comments Filed under: SSIS Snack

• SSIS Snack: Configuring an SSIS 2005 Lookup Transformation for a Left Outer Join

  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 Read More... Posted Tuesday, February 09, 2010 8:00 AM by andyleonard | 5 Comments Filed under: SSIS Snack

• SSIS Snack: Passing Parent StartTime to the Child Package

  Introduction Jack Corbett ( Blog - @unclebiguns ) tweeted recently about recording the start time of a parent package from the child package it called. I responded and ended up writing a small demo project in SSIS 2005 that you can download here . I thought Read More... Posted Monday, January 25, 2010 8:00 AM by andyleonard | 4 Comments Filed under: Design Pattern, SSIS Snack

• 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. Read More... Posted Tuesday, January 19, 2010 8:00 AM by andyleonard | 11 Comments Filed under: SSIS, x64, SSIS Snack, Excel

• 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) Read More... Posted Wednesday, January 06, 2010 8:00 AM by andyleonard | 0 Comments Filed under: SSIS, SSIS Snack