Monday, March 26, 2012

Running a DTS PKG from a DTS PKG

Any one have an idea how to run a dts pkg from a dts pkg. I have tired the following:
use msdb
EXEC sp_start_job @.job_name = 'PITA XLS OUTPUT'
and get the error that the job does not exhist.
any ideas?
JimOriginally posted by JDionne
Any one have an idea how to run a dts pkg from a dts pkg. I have tired the following:
use msdb
EXEC sp_start_job @.job_name = 'PITA XLS OUTPUT'

and get the error that the job does not exhist.

any ideas?
Jim

HEHE my bad u cant run a dts pkg with the run job sp :)
thanx anyways
jim

No comments:

Post a Comment