Testing a Package

With the data flow task completed, you are ready to execute the package in the Package Designer Debug mode.

Executing the Package in the Designer

This exercise shows you how to execute a package in the BIDS environment. There are actually a few different ways to execute or run a package. You will use the right-click menu from Solution Explorer.

Execute the QuickStartIS.dtsx Package

1. Right-click the package in Solution Explorer and click Execute Package.

   While the package is executing, switch between the Control Flow and Data Flow tabs to watch the boxes change from yellow to green as the execution progresses. Green boxes represent tasks that have completed; yellow tasks are still in progress. Notice that the tasks run concurrently.

   When a package finishes, you still have to stop debugging to continue.

Stop Debugging and Close the Package Designer

1. Click Stop Debugging on the Debug menu or click the Package Execution Completed link at the bottom of the designer window.

2. Close the package designer.

   Note 

   The color coding of tasks in execution mode is a good visual to remind you to stop debugging before you proceed to the next task. If you can't seem to move forward and can still see the colors on the screen, remember to stop debugging.

Review the QuickStartODS Database Tables by Using SSMS

1. In SQL Server Management Studio (SSMS), refresh the list of databases to see the new database.

2. Expand the Tables folder and review the tables that have been created.

3. Right-click dbo.ProductCategory and select Open Table to view the contents of the table.

4. Repeat these steps to open the other tables and to verify that records were appropriately imported.

5. Close each of the table window tabs when completed.