October 24, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Deploying and Configuring SQL Server Integration Services Packages Without the Wizard

  • October 2, 2008
  • By Dee Quang
  • Send Email »
  • More Articles »

Job Creation & Execution

Scheduling a package requires that a SQL Server job be created for the package. Load the Database Engine server type and connect using the LocalHost server name with Windows Authentication. After connection, navigate to the bottom of the LocalHost directory and expand the SQL Server Agent folder. Right-click on the Jobs folder and choose New Job... to display the New Job window. as seen in Figure 7.



Click here for a larger image.

Figure 7: SQL Server Job Creation

Give the job a name and navigate to the Steps tab on the left side to create a step process. Click on New... and a New Job Step window will appear, as seen in Figure 8.



Click here for a larger image.

Figure 8: SSIS Step Creation

Give the step a name and select SQL Server Integration Services Package as the type. Ensure that the value of Run as is SQL Agent Service Account. Now, navigate to the General tab located below the drop downs and select SSIS Package Store as the package source. Input LocalHost as the server and browse for the package in the file system. Select a package and the window should now resemble Figure 8. Click OK to close the window.

Now that the step is created, the package needs to be scheduled. Navigate to the Schedules tab on the left side of the New Job window and click on the New... button to display the New Job Schedule window. As seen in Figure 9, the New Job Schedule window is pretty self explanatory. Set the desired schedule and click OK to exit the scheduler.



Click here for a larger image.

Figure 9: SSIS Job Scheduler





Page 3 of 6



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel