• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

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?
0
realcoding
Asked:
realcoding
1 Solution
 
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
 
CboudrozCommented:
step by step explanation:
http://www.mssqltips.com/tip.asp?tip=1775
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now