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

My Thoughts on SQL Saturday #33

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

Human Doings

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

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

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

A Turning Point

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

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