Archives: February 2012
Execute Multiple 2008/2005 SSIS Packages with a T-SQL
If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this using T-SQL. First you will need a table with all of your package names on it. Then a While loop to execute each package.
Here is the example code:
Declare… Read more
6 comments, 812 reads
Posted in Mike Davis SQL on 16 February 2012