||MS SQL Server Administration: Running Packages In SQL Server 2005
A package after import in SQL Server Management Studio (SSMS) can be displayed in the file system folder. The package can then be run from there. The packages can be activated from within the SSMS and their progress of execution can be monitored in detail. The packages content cannot be reviewed within the SSMS and for that there must be export of package and thereafter opening of package in the Business Intelligence Development Studio (BIDS).
Steps To Run A Package
For running a package within SSIS, the following steps are involved:
- Open SSMS.
- Select Integration Services from the Server Type drop-down.
- Click Connect.
- Expand the Stored Packages folder.
- Expand the File System folder.
- Right-click the earlier imported package and select Run Package.
- The execute package utility runs.
- In the General options page are the package source, the server, the authentication, and the package name.
- Click the Reporting options page to see the available reporting options.
- Click the Command Line options page to see the command-line version of the execution. This capability is useful for automating the package execution in future (parameters can be added to the command line by selecting the option “Edit the Command Line Manually”).
- Click Execute for running the package.
- The Package Execution Progress window opens, displaying the package progress and information.
- Click Close for closing the progress window.
- Click Close for closing the execute package utility.
A pair of events can be logged in the Windows NT Application Event log by the execution of the package. At the start of the package, the source for these events are SQLISPackage with event ID 12288. The event ID is 12289 after successful completion of the package. The logged event ID is 12291 in case of failure of the package.