July 28, 2010 at 8:10 am
Hi,
Is if possible to have only one OLE DB Source and have it connect to multiple Connection Managers? I would like to use the same SQL script to connect to multiple Connection Managers to extract data and store it into one central place. I'll be using the same SQL user id and password for all Connection Managers if it matters.
In my SQL script I would like to use ClientID for each client connection for identification purposes.
July 28, 2010 at 3:06 pm
You can do something like this by setting up linked servers on your 1 data source server. Once you do that, you can write your code referencing the linked servers. You just have to be very careful with query efficiency. (when do you not? har har har)
You could also pull data from each source into recordset destinations, then do a merge join to combine the data in SSIS. It's really hard to say what the best method would be without getting a little more detail on the complexity of your data pull.
________________________________________
Get some SQLey goodness at Dirt McStain's SQL Blog
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply