AdSense

Sunday, 15 September 2013

SSIS Exercise 04

Create control flow and execute package
Start SQL Server Business Intelligence Development Studio (BIDS), open the project "SSIS Project" created earlier here and here completed till here.

Open the Toolbox window by selecting Toolbox from the View menu, locate the Execute SQL Task item, and drag it to the control flow workspace of your package.
01
Edit the Execute SQL Task object. This can be done by either of the following:

  • double-click on the task icon
  • right-click the task icon > click Edit.
Change the Connection property to use the AdventureWorks2008R2 connection
02

Update Execute SQL Task Editor > Statement Property, type:
UPDATE Production.Product
SET ProductLine = 's'
WHERE ProductLine IS NULL

03

Click OK in the Execute SQL Task dialog box. Then, right-click the Execute SQL Task > click Rename > and type Update ProductLine.
04

Now, drag a Sequence Container object from toolbox onto the control flow workspace.
Drag the just created Update ProductLine Execute SQL Task into the Sequence Container. This will ensure that the task is nested in the Sequence Container box.
05

Test the execution of the package by click Start Debugging on the Standard toolbar or choose Start Debugging from the Debug menu.
06

The Sequence Container and Execute SQL Task should be green after the package execution is complete.
07

To view the execution details - Click the Execution Results tab (which was named as Progress while the package is executing) in the SSIS Designer.
08

To stop the debugger, Select the Stop button from the tool menu or choose Debug > Stop Debugging from the Debug menu.
09

Click the Save All button to save the project.