Create and schedule SQL Server jobs with SSIS Packages | SansSQL

Tuesday, June 11, 2013

Create and schedule SQL Server jobs with SSIS Packages

In my previous post, we have seen how to use SQL Server Import and export wizard to import or export data and save the package.
When you save the package that is generated using this wizard, it is actually an SSIS package.
You can also use Visual Studio to create complex SSIS packages which performs the data extraction, transformation, maintenance of database, cleanup, etc...

There may be various reasons for saving the package, but one of those reason will be to automate.
The automation can be done by scheduling the SSIS packages using the SQL Server agent Jobs.

To schedule a job which executes the SSIS package,
  1. Connect to the SQL Server
  2. Expand the "SQL Server Agent"
  3. Right-Click on "Jobs" and Click "New Job..."
  4. In the new job creation screen, give the name of the Job, select Owner and its category
  5. Navigate to the "Steps" page and click "New"
    Provide the Step Name
    Choose the Type as "SQL Server Integration Services package"
    Choose the package source. The source can be either SQL Server or File System.
    Choose the package location
  6. In the "Advanced" page, you can set the advance job step options
  7. Now you can set the schedule to this job by navigating to the "Schedules" page or you may choose to run this job manually.
  8. Once you click "OK" and come out of the wizard, your new job will appear in the Jobs list and based on the schedule set, the job will automatically execute provided that the job is enabled and the SQL Server agent is in running state.

5 comments:

mtom said...
This comment has been removed by the author.
Timy Tons said...

Hello Web site owner. I seriously love this writing and also your webpage all in all! That write-up is very clearly written and also without difficulty understandable. Your WordPress design is wonderful as well! Would definitely be excellent to discover where I can get that. Be sure to hold up the great work. We all will need much more this sort of web owners such as you online and much less spammers. Superb mate! blockchain jobs marketplace

mtom said...

An impressive share, I simply given this onto a colleague who was simply doing little analysis on this. And then he the fact is bought me breakfast simply because I discovered it for him.. smile. So permit me to reword that: Thnx for any treat! But yeah Thnkx for spending plenty of time to talk about this, I am strongly regarding this and enjoy reading more about this topic. If it is possible, as you grow expertise, can you mind updating your blog site with a lot more details? It is actually extremely a good choice for me. Massive thumb up because of this article! jobs in India

Yousufzai said...
This comment has been removed by the author.
Ashish chauhan said...

Best restaurant in delhi

Post a Comment

Ads