Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: 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?
    Jim

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Running a DTS PKG from a DTS PKG

    Originally 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •