Scenario 6: How to remove header from a file ? For example the file content looks like as below: some Header here col1 col2 col3 col4 data1 data2 data3 data4 data5 data6 data7 data8 data1 data2 data3 data4 data1 data2 data3 data4 Some footer here Just we have to remove header from the file. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com