By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,312 Members | 1,666 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,312 IT Pros & Developers. It's quick & easy.

Attention All GURUS: Importing Mulitple MDBs in SQL Server 2005 Using SSIS

P: n/a
I am trying to import identical MDBs (Access Database) columns into SQL
Server 2005 using foreach loop in SSIS. The data and file name of the
MDBs are not the same; however the structure (column) is. I do need to
capture part of the file name and insert it into the destination column
(i.e. Year). I've used the foreach loop with the flat file connection
manager, and was able to capture any part of a text file name and insert
it into the destination without any issue. There, one just needed to
notify the loop editor where the files were located, how one would
enumerate and create a user variable that would be used in the flat file
connection manager. Then I right clicked the flat file connection
manager and chose properties to change the connection string to the user
variable from above.

Unfortunately, setting up the MDB loops have proven to be more difficult
and I cannot find information about it anywhere. The information that
I've found had to do with writing scripts using the DTS packages and not
SSIS. It is vitally important that I use the tool's components as much
as possible so that it is robust for latter alterations and I am also
relatively new to programming.

Can anyone provide me information on "how to" using the foreach loop
container with the OLEDB Connection Manager? Or notify me of another
solution to this troubling issue?

Your assistance in this matter is truly appreciated.

*** Sent via Developersdex ***
May 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.