[SSIS] Run SSIS package with command line command

摘要:[SSIS] Run SSIS package with command line command


1.Open VS Create SSIS package

2.Create command line command to execute specify code dtexec to run SSIS package, and build the command line come in a bat file

Ex.

dtexec /F "E:Package4.dtsx" >> E:logfileslogtest.txt

3.You can run the bat file on your System Task Schedule anytime

4.Or you can also run the package with MS SQL Agent