Problem: How to run SSIS
package on a scheduled basis?
Solution: Create a SQL Server Agent Job
In some cases, you may want to run the
data extraction daily to get the data ware house refreshed with the latest
data. As, we cannot daily run on a manual process. We may have to schedule the package
to execute on SQL Server agent as a job.
Example:
In this article, I am going to show we can create a job to
execute the SQL Server Agent job.
For
example, we have invoice details and invoice year, date and invoice id.
Step 0:
Create a new job from the SQL Server Agent.
Step 1: Add
job name and enable the check box.
Step 2: Go
to the steps tab, add a step name by clicking on new button like below.
Step 3: In
the steps dialog from the Type drop down select the SQL Server Integration
Services Package.
Step 4: after
the package type is selected you would be prompted to browse the package
source, here I am going with file system.
Step 5:
Create a schedule to run daily/ weekly/monthly.
Step 6:
Confirm the job exists on SQL Server Agent Jobs list.
Results:
0 comments:
Post a Comment