Post reply

how to call a dts from stored proc

  • May 6, 2004 at 3:28 am

    #76158

    Hello,

    did somebody know the syntax how to call a dts from a stored procedure?

    Thanx

  • May 6, 2004 at 6:24 am

    #505451

    EXEC master..xp_cmdshell 'DTSRun /S "(local)" /N "PREPROCESSING_DICTIONARY import" /W "0" /E'

    read help info on xp_cmdshell and DTSRun

    command line utility dtsrunui offers a gui to build the above string and export it, so you don't have to figure out all the syntax

  • May 6, 2004 at 7:16 am

    #505466

    hello woast,

     

    thank you, it seems to work........

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply