Tag Archives: Examples

Insert Parent and Child Tables with SSIS Part 2

Examine a different approach for inserting data into parent child tables with SSIS Continue reading

Posted in SSIS | Tagged , | Comments Off on Insert Parent and Child Tables with SSIS Part 2

Inserting Parent and Child Tables with SSIS

Examines a simple pattern in SSIS for handling parent and child tables Continue reading

Posted in SSIS | Tagged , | Comments Off on Inserting Parent and Child Tables with 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