can a sql 2005 ssis package be scheduled ?

down vote favorite
      

I have a data dump that I manually initiate and I want to automate things now that they are working well. I have a system that exports data into Excel that I ultimately want to import into a SQL table.

I have a ssis package that I used for the import and saved it for re-use later. I just manually ran it and it works well. Now I would like to have it run either when invoked by a file watcher or schedule or some thing so that all I need to do is over-write the excel file and have it trigger the ssis to run its import.

Any ideas on how to make this happen?
realcodingAsked:
Who is Participating?
 
CboudrozCommented:
step by step explanation:
http://www.mssqltips.com/tip.asp?tip=1775
0
 
HumpdyCommented:
you can create a job within SQL Server which can be scheduled to run your SSIS package.
When you create a new step in your job, you can choose SSIS package in the Type droprown box.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.