Executing a Package in BIDS


By:
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:

pen project

Expand the SSIS Packages node under the Tutorial-Sample-1 project in Solution Explorer and you will see the following:

olution explorer open package

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:

xecute package control flow

Here is the Data Flow after the package has run successfully:

xecute package data flow

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):

xcel spreadsheet

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.






Comments For This Article




Friday, March 19, 2021 - 8:31:15 PM - Rodolfo GM Back To Top (88446)
to solve the problem "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + @[User::FullPath] + ";Extended Properties=\"Excel 12.0;HDR=YES\"

can you simply execute on 32 bits. Right clic on Tutorial-Sample-1 clic on properties and then on the debbuging tab > debugging options > Run64bitRuntime. Set on FALSE

Tuesday, March 22, 2016 - 2:44:18 AM - Milan Back To Top (41023)

 

 Perfect article to start with SSIS. Learned so many things.















get free sql tips
agree to terms