SQL Server Performance Forum – Threads Archive
How to create SQL job to exec SSIS package?Are there any articles to direct me to create a SQL job which can execute SSIS package on SQL server 2005?
By the way, on SQL server 2000 I use DTSRUN.exe in SQL job to run DTS. I tried to find the similar way to do this. Thanks for recommendation,
DTS is left for legacy application packages only and you wouldn’t be able to do same in SQL 2005. Refer tohttp://mssqltips.com/tip.asp?tip=1180 to schedule SSIS package. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.