Developing and Deploying SQL Sever Apps on Windows Integrity

26 of 39

MsgBox("The max number of Addresses in the table is" and

strTheId, 0, "SSIS Script Task Example")

connection.Close()

' String Defenition

Dts.Variables("sqlint").Value = strTheId

' Test

MsgBox(Dts.Variables("sqlInt").Value.ToString)

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

6. From the Build menu, Select the Precompile option as shown.

7. From the Debug menu, select start debugging. At the end of a successful run the

script task ill displays the number of records moved as shown in the figure below.

8. Deploy and execute the package at the IA64 machine. As described in the section 2.3,

item 14, Set up the remote debugger environment and start debugging the package

from the IA64 machine.

9. The SSIS package executes under the configured SSIS account (DTS Server).

Therefore, you must consider whether the actions taken by your Script Task have the

appropriate authority.

10. Script Task allows you to access SSIS Package variables and change SSIS Package

behavior. However, as you develop your own Script Tasks, you must consider things

like transactions and error handling.