How to schedule an SSIS package job in SQL Scheduler or Windows Scheduler?

Question

I created a package (SSIS) that contains SQL procedures for transferring data from tables. It is in .dtsx format in accordance with the SSIS package. Now, how to add this to the schedule so that it starts automatically every 3 months. I can’t get information through Google.

Windows also has a scheduler, but it only runs .exe files through the scheduler. Can I convert between .dtsx to .exe?

Also how to add this to the SQl server scheduler? Please help. Any link would be helpful as well.

Answer 1

You can run your SSIS package using the dtexec , for example, from the dos command line

 dtexec /f %PackagePath%\%PackageName% /conf %PackagePath%\%ConfigName% 

you just add this command to the batch file (.bat) and plan it in your scheduler.

Check out this link on the DTEXEC utility

http://msdn.microsoft.com/en-us/library/ms162810.aspx

Hope this helps.

Answer 2

Another solution is to schedule packages using SQL Server Agent and create a task so that you can run it every 3 months.

Answer 3

You can also schedule your SSIS package using the following files:

 "C:\Program Files\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /f "D:\Package.dtsx"