.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Schedule SSIS Package using SQL Server Agent

Posted By:Rajeev Kumar Mehta       Posted Date: October 08, 2010    Points: 5    Category: DataBase    URL: http://www.dotnetspark.com  

This article show Step by Step Process to Schedule a SSIS Package using SQL Server Agent
 

Schedule SSIS Package using SQL Server Agent

 

            Step 1 : -  Set your SSIS packages properties as :

 

           Go to Security tab and then Set

       ProtectionLevel : EncryptSensitiveWithPassword

 

        PackagePassword : temp (any password you like )

 

             Step 2 : Build your  SSIS Project

 

             Step 3 : Login into SQL Server Integration Services

 

Step 4 :  Go to MSDB folder


Step 5 :  Right Click on MSDB folder and then New Folder and give the name say SSISPackage and then right click on SSISPackage and then Select Import Package.


Step  6 : Select Package Location : File System and then Broswe your package by clicking ellipse button infront of Package Path .

 

Step 7 : Select Protection Level as :  Encrypt sensitive data with password and then enter your package password (temp which we already set in our package).

 

Step 8 : Click Ok. Then again enter your package password (temp) which we entered in the previous step.

 


Step 9 : Log in to Sql Server Management Studio and Select Database Engine

 

 

Step 10 : Go to Sql Server Agent and then Right Click on Job and Select New           

              Job.

 

Step 11 :  In General tab : Give a name to your Job say ScheduleSSIS and give any description (optional)

 

Step 12 :  Go to Steps tab and then click New. Settings

 

(a)  Step Name say as Step1.                

(b).Select SQL Server Integration Services Package in Type

(c )Run as: SQL Server Agent Service Account.

(d) Package Source : SQL server

(e) Server : IP or Server Name

(f) Windows or SQL Server Authentication of the SQL Server where we have s         

      stored our SSIS Packages

(g) Click ellipse button infront of Package and then Select your SSIS Package you     

      want to schedule.

 

 

Step 13 : Select Your Package and then click ok and then enter the package      

              password.

 

Step 14 : Go to Schedule tab and then click New and give a name to Schedule sal Schedule1 and Schedule Type : Recurring and rest of the setting as per your requirement and last click OK.

 


You are through.

Your SSIS Package has been Successfully Scheduled.

 

 

All Queries are Welcome !!!

Rajeev Kumar Mehta

Email - mikkykumar@yahoo.com,mikkykumar@gmail.com


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend