May 20, 2010 at 10:56 pm
Hi Experts,
We have got a project in which we will be getting many flat files in one particular location ..These files are of different type and every file will be having one header and footer.
How can we find the type of each file or how can we proceed in inserting the values from file to tables using SSIS?
Thanks In Advance
May 26, 2010 at 2:32 am
In the For Each loop, you can set the property FileSpec to a filetype, so that the loop only takes the file of that specific filetype. For example, if you set it to *.xls, you will get all Excel files.
So you'll have to create a for each loop for each filetype. Then I hope for your sake that each file of a specific filetype is generic, meaning, the layout doesn't change from file to file. Otherwise you have to create seperate data flows for each specific layout, or write a dynamic script that will do the ETL for you.
In most flat file sources you can select that there is a header and that is either containts the column names or that you just want to skip that row.
To get rid of the footer you probably have to use a conditional split.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply