Developing and Deploying SQL Sever Apps on Windows Integrity

24 of 39
Script Task must be compiled before the package runs in a 64-bit environment. If you do not
use the default precompile option, the script is compiled at run time and will not work on
Integrity. Run time compile slows package execution, however the draw back is that a
precompiled script cannot be debugged without all the relevant files.
Using the package we created in the preceding sections, we’ll extent it with VB .NET code. This
sample script task will show a message in a message box about how many records are
transferred from source to destination at the end of the SSIS package run. This example also
shows how a variable can be used to pass the value at run time.
1. In Business Intelligence Development Studio, open the Integration Services project.
2. On Control Flow Task, from Tool set, select Script Task and drag it to the Control Flow
Area. Connect the input to the script task to the output of data Flow task we already
created on section 3.1.1 above.
3. From the project’s SSIS menu, select variables. Type variable names and other details
as shown in the figure below.
4. Double-click the Script task component. Select the “Script” tab. Select the entries as
shown.