Running Packages

You can use various options to run an Integration Services package. Your choice of tool or utility can be guided by various factors.

BIDS

You can run your packages from within BIDS while you are developing, debugging, and testing your packages. You can run your package by pressing F5 or by right-clicking the package in Solution Explorer and choosing Execute Package option from the context menu. You have already used these options while developing packages in the last chapter. Remember that when you run a package in BIDS, a Progress tab appears to show how the package is doing while the package is running, which finally converts into an Execution Results tab when you switch to design mode or stop debugging on package completion. ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.