Home Forums SQL Server 2005 Business Intelligence How to execute a ssis pkg and set a ssis variable value in that pkg from TSQL RE: How to execute a ssis pkg and set a ssis variable value in that pkg from TSQL

  • DTS isn't a command. It's a switch telling dtexec that the package is stored in the SSIS package store. You need to put dtexec at the start of your command line.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP