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 Snack   (RSS)
Showing page 1 of 2 (13 total posts)
  • 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: 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 SSIS Snack: The Trash Destination Adapter. The green arrow between the ''Dummy Source'' ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2010
  • 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 toolbox and click Choose Items:   When the Choose Toolbox Items ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 4, 2010
  • 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, one way is to use an OLE DB Source. Drag it onto the data flow canvas and open the ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 3, 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 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, I'm an engineer. I learn an awful lot by testing - I sometimes refer to this as my ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 16, 2010
  • 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 the output of the Lookup (''Correlate'') to it. Open the editor, we're going to add ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 11, 2010
  • 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 Adapter, connect to AdventureWorks and use the following T-SQL statement to extract data from ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 9, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement