Configure the connections of an SSIS package with SQL Server authentication.Determine the path to the desired version of DTExec.exe.The path to a configuration file can be added to override parameters hard-coded into the package, along with other switches to select execution options such as error output mode and log file path.
The DTExec.exe command requires one parameter, the path to a valid SSIS package. Business Intelligence Development Studio is well-suited to creating and testing SSIS packages, but batch files using the DTExec command are a more convenient means of executing production SISS packages.
