Windows Task Scheduler for running a SSIS Package.

Below script can help to schedule ssis package in Windows task scheduler.

Put below code in note pad and save it as .bat file.

Replace package path in below command


"C:\Program Files\Microsoft SQL Server\110\DTS\Binn\dtexec.exe" /FILE "C:\Users\Documents\Visual Studio 2010\Projects\Integration Services Project1\Integration Services Project1\Package1.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /REPORTING EWCDI.

Open Task scheduler in

STart ---> Run----> task Scheduler---->Create Task---->Actions---->Browse bat file location