February 2011 Entries

SSIS Technique to Remove/Skip Trailer and/or Bad Data Row in a Flat File
I noticed that the question on how to skip or bypass a trailer record or a badly formatted/empty row in a SSIS package keeps coming back on the MSDN SSIS Forum. I tried to figure out the reason why and after an extensive search inside the forum and outside it on the entire Web (using several search engines) I indeed found that it seems even thought there is a number of posts and articles on the topic none of them are employing the simplest and the most efficient technique. When I say efficient I ......

Posted On Tuesday, February 15, 2011 4:57 PM | Comments (7)

SSIS 2008 Configuration Settings Handling Logic for Variables Visualized
There are many articles discussing the specifics of how the configuration settings are applied including the differences between SSIS 2005 and 2008 version implementations, however this topic keeps resurfacing on MSDN’s SSIS Forum. I thought it could be useful to cover the logic aspect visually. Below is a diagram explaining the basic flow of a variable setting for a case when no parent package is involved. As you can see the run time stage ignores any command line flags for variables already set ......

Posted On Wednesday, February 2, 2011 6:10 PM | Comments (1)