Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Question Unanswered: How to run DTS from stored proc

    I am running a DTS package from stored proc as,

    Exec [master].[dbo].[xp_cmdshell] "dtsrun /S Server /U User /P Pass /N Package Name"

    But i am getting an error :

    The system can not find the path specified.

    But i am able to run the same from DTS Design Wizard.

    Please anyone of you help me out.

  2. #2
    Join Date
    Oct 2003
    Posts
    83
    set @str varchar(8000)
    set @dtsname varchar(8000)
    set @dtsname=physical path and name of your dts package
    SET @str='DtsRun '+ '/F ' + @DTSNAME

    EXEC master..xp_Cmdshell @str


    I believe it will help you

    Subhasish Ray

    subhasishray@sify.com

Posting Permissions

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