Calling ALL SSIS GURUS
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.
Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
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.
Thanks!
*** Sent via Developersdex http://www.developersdex.com ***