SSIS – Scheduling a SSIS Package in a SQL Job

If we need a config file.

If we need to embed credential in the connection string in the data source.

If we need to use Command Line (It’s an example where a SSIS package creates an Excel file.).

Or,

"D:\MSSQL2005\MSSQL$HSVR11 (x86)\90\DTS\Binn\DTExec.exe" /DTS "\MSDB\etl_Send_Excel" /SERVER lsvrname /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V