Tag Archives: Flat Files

Processing Flat Files with SSIS at SQLSaturday #61

I’m looking forward to speaking at SQLSaturday #61 (#sqlsat61) in Washington, DC this coming weekend (12/4/2010). As usual for a SQLSaturday, there are some great speakers scheduled to present. I’ll be presenting on “Processing Flat Files with SSIS”, which goes … Continue reading

Posted in SQL Saturday | Tagged , | Comments Off on Processing Flat Files with SSIS at SQLSaturday #61

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