SSIS Import from Multiple Databases
Home > IT Answers > SQL Server > SSIS Import from Multiple Databases
RobH
5 pts.
0
Q:
SSIS Import from Multiple Databases
SSIS 2005, SQL Server Integration Services
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?
ASKED: Jul 13 2009  9:57 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Use a script task to change the connection string properties of the connection object that the source of the data flow is using.
Last Answered: Jul 13 2009  10:51 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0