I previously wrote article SQL SERVER – Import CSV File into Database Table Using SSIS. I was asked following question by reader that how to run the same SSIS package from command prompt. In response to the same I have written article SQL SERVER – Running SSIS Package From Command Line. Within few minutes of the blog post, I received email from another blog reader asking if this can be scheduled in SQL Server Agent Job.
Absolutely, SSIS package can be scheduled in SQL Agent Jobs. Here is quick note on how one can do the same.
First you can create new job from SQL Server Agent Menu.
Create New Step.
Select Type as SQL Server Integration Services Packages. Select Package Source as file system and give package path.
Now click on OK, which will bring you at following screen.
On next screen you can select schedule and configure desired schedule.
You can notice this is very easy process. Let me know if you have any further questions.
Reference : Pinal Dave (http://blog.SQLAuthority.com)