By: Ray Barley
Overview
This is our fifth and final step in creating a simple SSIS package from scratch. In this section we will execute the package from within BIDS.
Explanation
To begin launch BIDS by selecting SQL Server Business Intelligence Development Studio from the Microsoft SQL Server program group. Click File, Open, Project / Solution on the top level menu to display the Open Project dialog. Navigate to the location of the solution as shown below then click Open:
Expand the SSIS Packages node under the Tutorial-Sample-1 project in Solution Explorer and you will see the following:
Right click on the SSIS package CreateSalesForecastInput.dtsx and select Execute Package from the popup menu. While the package is running you will see each task turn green if it completes successfully or red if it fails. Here is the Control Flow after the package has run successfully:
Here is the Data Flow after the package has run successfully:
After the package completes click Debug on the top level menu then select Stop Debugging.
We can open the Excel spreadsheet that the package created and see the following (only a portion of the spreadsheet is shown):
The above spreadsheet shows the columns from our query plus the Forecast column which we added with the Derived Column task. This completes our tutorial section on creating a simple SSIS package.