AndyLeonard.blog()

I’m excited to present Applied SSIS Design Patterns to the Triangle SQL Server User Group 16 Mar 2010! This is a reprise of my PASS Summit 2009 spotlight session. If you read this blog and make the meeting, introduce yourself!  :{> Andy  

Another quick survey question, slightly off-topic: How’s your economy? Have things picked up for you recently? Slowed down? Remained static? :{> Andy

One or two quick survey questions: Do you manage T-SQL scripts in source control? If so, which source control product / platform do you use? :{> Andy Note: I moderate comments, so your comment will take some time to publish.

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. …
Continue reading SSIS Snack: Grid Data Viewer

Introduction  I am presenting today at SQL Saturday #33 in Charlotte, NC. Peter Shire and the other organizers have really outdone themselves. In my opinion, this event raises the bar for SQL Saturday events and elevates this particular event to the regional level. Peter and the crew are to be congratulated: They reached out personally …
Continue reading My Thoughts on SQL Saturday #33

Introduction This post is the fifteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, …
Continue reading Human Doings

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 window displays, click the SSIS Data Flow Items …
Continue reading SSIS Snack: The Trash Destination Adapter

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 …
Continue reading SSIS Snack: Data Preview

Introduction This post is the fourteenth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is Organic, …
Continue reading A Turning Point

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 Final (?) Destination Drag an OLE DB Destination …
Continue reading SSIS Snack: OLE DB Destination 1