Tag Archives: SSIS

Handling Flat Files with Varying Numbers of Columns

5/15 Update – I added Part 2 to show how to do the same thing with a Conditional Split and a Derived Column transform, per Jamie’s feedback (see the comments on this post). A common question on the forums has been how to … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Handling Flat Files with Varying Numbers of Columns

Handling Multiple Errors in SSIS

[edited on 12/14/2007 to correct an error in the text around string handling – the samples were not modified] One actual failure in SSIS can trigger a whole series of error messages. For example, failure to convert a column value … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Handling Multiple Errors in SSIS