August 22, 2007 at 1:11 pm
Hello all, I am about to create my first SSIS package and I am a little confused about a couple things.
I have a folder with a bunch of access DB's. I want to use a SSIS package to loop through these DB's and retrieve data from certain table(i.e. document_part, document_model).
I have a Foreach Loop container but I do not understand how to tell it to loop through the DB's to get the table desired. When and if I do loop and get the data I will use some type to sql query to insert this gathered data into a SQL server 2005 table.
any help is appreciated thanks...
zach
August 22, 2007 at 3:00 pm
http://www.sqlmag.com/Articles/ArticleID/95385/95385.html
This SSIS package besides accessing multiple databases can access multiple servers
David Bird
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply