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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
