Home Forums SQL Server 7,2000 General pass parameters to dts using xp_cmdshell rundts RE: pass parameters to dts using xp_cmdshell rundts

  • I am running the following:

    master..xp_cmdshell 'dtsrun /S ricmssql02 /U admindw /P letmein /N "scott - debug"'

    but also send parameters. I am seeing the following to do that:

    /A global_parameter_name:typeid=value

    And also that the whole thing can be repeated to send multiple.

    My questions are; What is the delimiter for multiple? What are the values for typeid?

    I have Googled and looked at msdn and can't find a good explanation.