SSIS execution from SQL Server TSQL 1

[sparkbyte]

How do you execute a SSIS package that has been deployed to the server. NOT to the file system? I have found many examples of how to execute DTSX packages from the local file system Example but have not been able to find any examples of how to run a package that has been deployed to the server.

Thanks

John Fuhrman
faq329-6766
thread329-1334328
thread329-1424438

 

[RiverGuy]

I usually put the SSIS package in a SQL Agent job and call sp_start_job.

 

[sparkbyte]

Thanks I will look into sp_start_job.



Thanks

John Fuhrman
faq329-6766
thread329-1334328
thread329-1424438

 

[NP14]

I wrote an article on how to execute SSIS package using various methods including from T-SQL

http://www.bidn.com/articles/ssis-a...ing-parameters-t-sql-vb-net-c-sqlagent-dtexec

Hope this helps

 

[sparkbyte]

Thanks I am printing it now to add to my collection.

Thanks

John Fuhrman
faq329-6766
faq329-7301
thread329-1334328
thread329-1424438