March 4, 2021
Hot Topics:

Deploying and Configuring SQL Server Integration Services Packages Without the Wizard

  • By Dee Quang
  • Send Email »
  • More Articles »

Create a new folder under LocalHost\Stored Packages\File System to separate the projects and import the packages by right-clicking on the newly created folder. Choose Import Package...when the right-click menu pops up. This should bring up the Import Package screen, as shown in Figure 4.

Click here for a larger image.

Figure 4: Package Import

Select File System as the package location and browse for the package's location. Once the package is selected, click on the package name input box and a suggested name will appear. The name that appears is simply the name of the package. Feel free to change it by overwriting the value in the box. When done, click OK to complete the import. Figure 5 displays how the directory should look like after the packages are successfully imported into SQL Server's file system. (If you were to use the BIDS deployment wizard, this is as far as it will take you. Therefore, you have essentially performed all the steps that were to be performed by the deployment wizard!)

Figure 5: SQL Server File System


After all packages are imported, there are two methods to execute the package. Packages can execute by scheduling the package with the SQL Server Job Agent (SSJA) or on an ad-hoc basis by choosing to run it from SQL Server's file system. All packages can be configured in their respective methods of executing. However, configurations will not be explained until the Configuring Packages section. The packages will currently run off the default package configurations.

SQL Server Job Agent

Packages that need to be processed in a timely manner can be scheduled by the SQL Server Job Agent. To use SSJA, the services need to be enabled. Navigate to the Services folder by going to Start→Settings→Control Panel→Administrative Tools→Servicesand locate SQL Server Agent (MSSQLSERVER). Make sure that the service is enabled. If not, right-click on SQL Server Agent and choose properties. Under the General tab of the Properties window, select Automatic for the startup type and click on the Start button. Figure 6 below displays the Properties window.

Figure 6: SQL Server Agent Properties

After Start is pressed, the SQL Server Agent should now be started. Click OK to close the window and get out of the Services folder.

Page 2 of 6

This article was originally published on October 2, 2008

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date