Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    15

    Unanswered: Run DTS from query

    Hi ya!

    How can I run a DTS from a query?


    Thanks!

    Ken

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    I'm not sure if this would work, but it might....

    I don't think you can directly run a DTS package from the Query Analyzer....

    But what you could do is use the Query Analyzer to create a job which executes the DTS package and then deletes the job it created....

    Schedule a Package, then go to jobs and do a "generate script" and that should give you an idea of what the SQL should look like...

    If you want to go this way and need help let me know, I haven't done it but I wouldn't mind playing around with the idea...

  3. #3
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    exec master..xp_cmdshell 'dtsrun ....'

    You can also use sp_oa... see
    http://www.nigelrivett.net/sp_oacrea...TSpackage.html

Posting Permissions

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