Scenario 5: How to remove footer from your 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 footer Just we have to remove footer from the file. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

skipping trailer records: http://microsoft-ssis.blogspot.com/2011/02/how-to-skip-trailer-records.html But this could also be found in this forum with some searching.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

you can redirect the footer to an error table or nothing at all by using SPLIT , or a SQL within SSIS DFTSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Another approach is to use a Script Component as a Source, and determine if the current row is a Header, Detail, or Footer, and direct the data down one of three appropriate Output data flow pipelines. This is handy if you have actual data in the Header and Footer that you need to capture somehow. The issue with this is that you cannot set the order in which the rows are generated.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

You can use a conditional split to split the footer from data.Keerthi Kiran Senior Consultant Ph - 9632745745

you can redirect the footer to an error table or nothing at all by using SPLIT , or a SQL within SSIS DFT Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). You can use a conditional split to split the footer from data. Keerthi Kiran Senior Consultant Ph - 9632745745 Correct, but only if you can distinguish the trailer record from the rest.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com