Home > IT Answers > SQL Server > SSIS Import from Multiple Databases
RobH
5 pts.
 SSIS Import from Multiple Databases
SQL Server Integration Services, SSIS 2005
How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

Software/Hardware used:
ASKED: July 13, 2009  9:57 PM
UPDATED: July 14, 2009  12:51 PM
RELATED QUESTIONS
Answer Wiki:
Use a script task to change the connection string properties of the connection object that the source of the data flow is using.
Last Wiki Answer Submitted:  July 13, 2009  10:51 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _