Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS run against multiple databases

Author  Topic 

dwalker79
Yak Posting Veteran

54 Posts

Posted - 2009-01-22 : 15:33:45
Can anyone tell me a simple approach to running one SSIS package against multiple databases on different instances with a SQL Server Agent Job?

Thanks!
Dustin

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-23 : 11:31:21
use package configurations
http://www.mssqltips.com/tip.asp?tip=1405
Go to Top of Page
   

- Advertisement -