June 25, 2009 at 12:01 pm
I have a scenario here we get flat files on a weekly basis and these files have a Header record and Tail record which is actually different from the actual data the flat file contains. When we create a package to process these files is there a functionality using SSIS which would loop through the flat file and skip those 2 records and fetch the remaining?
Regards
June 25, 2009 at 1:42 pm
So there is a header row and footer row that you want to skip? You can setup the file connection to skip the header row.
You could also use a script component instead of a flat file source to process the file and skip the header and footer rows. See this article[/url] by Tim Mitchell to see how to access a flat file with the script component.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 25, 2009 at 2:56 pm
Thanks Jack for the information provided. It was of great help.
Regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply