468,110 Members | 1,775 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,110 developers. It's quick & easy.

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

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 http://www.developersdex.com ***
May 4 '07 #1
0 1420

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Howard | last post: by
5 posts views Thread by Peter Nurse | last post: by
2 posts views Thread by Anna | last post: by
3 posts views Thread by scoots987 | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.