May 27, 2008 at 1:09 pm
forgive me if this is a simple question, but how would
i import more than one .xls file into a single table?
i know i can import using one .xls, but how would it
work if i had maybe 3 or 4 .xls going into the same
table?
ultimately i would like to have an import use only
say... a wildcard. specifically only .xls files that
begin with monday*.xls in a folder.
(most of the files have a timestamp, and would rather
ignore that part of the file, and grab them all one once)
May 27, 2008 at 1:15 pm
I believe you could use a foreach loop container in SSIS to grab each Excel file and insert, as long as the "column" names match in each file.
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
May 27, 2008 at 2:49 pm
is there a quick how-to on that? i have 'data flow' task
which was built by the wizard, and now u just need to modify
it to accept more than one .xls.
i placed the 'for loop' in the center of the work space, and
now dragged the 'data flow' task into it.
i've got a red 'x', and need to specify some kind of expression.
any info on that process would be helpful.
thanks again for your comments.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply