How to schedule a SSIS package job in SQL sheduler or Windows scheduler?

Question

I have created a (SSIS) package which contains SQL procedures for transfer of data from tables. It is in .dtsx format as per SSIS package. Now how to add this to a schedular so that it runs automatically after every 3 months. I am unable to get any information through google.

The windows also has a scheduler but it runs only .exe files through scheduler. Can I convert between .dtsx to .exe?

Also how to add this to the SQl server scheduler? Please help. Any link will be useful also.

If you can deploy package on SQL server then you can schedule it thru SQL job. — pramodtech, Nov 17 '11 at 05:22

score 6 · Accepted Answer · answered Nov 10 '11 at 12:42

You can run your SSIS package using dtexec command like from dos command prompt

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

you just add this command to a batch file (.bat) and have that scheduled in your scheduler.

Check this link on DTEXEC utility

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

Hope this helps.

score 2 · Answer 2 · answered Feb 05 '13 at 09:03

2

An other solution is to schedule the packages through SQL Server agent and creating a job so that you can scedule it once in 3 months.

answered Feb 05 '13 at 09:03

Dibin

1,508
1
15
19

score 2 · Answer 3 · edited Jul 14 '15 at 07:16

2

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

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

edited Jul 14 '15 at 07:16

shapiro yaacov

2,308
2
26
39

answered Jul 14 '15 at 06:30

Manisha Agarwal

101
1
3
10

How to schedule a SSIS package job in SQL sheduler or Windows scheduler?

3 Answers3

Linked