March 2, 2011 at 1:39 pm
I(company I work for) has a lot of data in flat files and excel, which is making it difficult to create reports on. I was originally going to create a tool for importing this data using c# and vsto however SSIS looks like the best solution and will be useful for other projects with flat files.
We use SQL Server 2005 for reference.
My current problem is that we have excel files that come in as emails and are saved in a specific folder -> yearfolder -> monthfolder. So my problem is that it is not one excel sheet but many excel sheets that have the same template. From my quick look at ssis it appears as if I can only connect ssis to one file, whereas I need to pull data from many files in varying folders(the folders are named in a pattern).
My question is can I solve this with SSIS? If so can I get a very very short description of what I need to learn / do for this problem.
Thanks.
March 2, 2011 at 1:45 pm
I suggest you read up on the use of Foreach loops to process one file after another.
(You said keep it short:-))
March 2, 2011 at 1:51 pm
I'll take short!
Really I just wanted to know if it was possible before I invest time on a solution that may not be possible.
Thanks
March 2, 2011 at 1:56 pm
As long as the files have consistent formats (same order/number/data type of fields), it is possible.
SSIS is not good in scenarios where you want to be able to handle file formats dynamically at run time (because you don't know the format in advance, or because you want to read the format from a table, for example).
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply