SQL Server and MS BI With a Geek Touch

It is very simple to schedule the SSIS packages using windows Task Scheduler. Just follow the steps below.

Step 1: create a batch file (.bat or .cmd) file with the command to execute the SSIS packages using “dtexec” it may be as simple as the command below.

“C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe” /FILE “C:\FY11PackagesAndReports \DataPullv2.dtsx” /MAXCONCURRENT ” -1 ” /CHECKPOINTING OFF /REPORTING EWCDI >C:\ FY11PackagesAndReports \logsIP.txt

Step 2: Save this batch file (.bat) in a folder.
Step 3: Select Task scheduler from the programs ( start Menu)

Read more…