Thursday, March 22, 2012

Executing a DTS Package

I am using SQL 2000. Can I execute a DTS package from a
stored procedure or from a TSQL script?
Thanks.If you create a job in SQL Server Agent you can use the DTSRUN command. That
job could then be executed from within a proc using sp_start_job
--
HTH
Ryan Waight, MCDBA, MCSE
"dschrier" <deena_schrier@.viarail.ca> wrote in message
news:1cd801c38757$cce77050$a101280a@.phx.gbl...
> I am using SQL 2000. Can I execute a DTS package from a
> stored procedure or from a TSQL script?
> Thanks.sql

No comments:

Post a Comment