• To Call DTS:

    1) use dtsrunui.exe (in 80/tools/bin under SQL Program Files) to generate a DTSRun command string.  Set variable FY="default value" to generate global variable portion of command line.

    2)  Copy command line and set a varchar variable in proc to that value.

    3)  replace "default value" in string with a "server" parameter from proc (using string concatenation)

    4)  exectute xp_cmdshell with pre-concatenated string.

     

     

    Signature is NULL