asp.net in SQL Server 2008 set up services (SSIS)

asp.net in SQL Server 2008 set up services (SSIS)

The Script task allows you to access Microsoft visual for the Application (VSTA Edition) Studio tool Environment, write and

Execute scripts using VB and C # languages. The environment in China is the latest version of the new SSIS, replacing the version from 2005

The Visual Studio Instrumentation (VSA) environment for the application. The script is now almost inappropriate because the latest version

The SSIS consolidated connection to full. For VB and C#net Library. Recently, in addition to the general Chinese environment and the Scripting task of SSIS

These additional functional advantages are also provided:


A same smart advantage coding environment
SSIS in an integrated Visual Studio design environment
A usage that is easy to pass to script parameters
Ability to add to your code for testing and debugging breakpoints (with only one Script task per package)
The speed advantage of automatically compiling scripts into binary format (this is configured in an earlier version of SSIS.) ）
The script task is passed in the Configuration Script Task Editor Script tab (shown in Figure 3-6).

Figure 3-6

The ScriptLanguage property is the one you selected. NET language you, like to use in the task gratified. Please note that the default language is set

Set to C #, so if you are coding vb.net, don, through these settings of your script task, AOT

Wizards. If you do anything with the previous version of SSIS development, you äôll also notice

The Precompilescriptintobinarycode property has been permanently deleted. As a result, all of the scripting code will be from

Dynamic compilation and continuation to the package. This speed, and reduce the run-time error of the task significantly.

For the EntryPoint property, you can provide a Scriptmain class instantiation at the start of another function call. Usually

You, Äôll leave this set to the default main () function. In ReadOnlyVariables and

The Readwritevariables property allows you to pass to a variable named as a comma-delimited listing script SSIS

Amount The name of the typing variable comes from an earlier version of a small SSIS that is unconventional, but the latest version provides a bangs

A variable for the ability to collect and select variables. Having these variables provides an important advantage of coding. You just

To mention the ordinal position or the name of the variable set to them can access the lock worry don't worry about their values

, unlock, or block in read-write operation variables. You just make sure you have the variables you want to write back in the

Readwritevariables property, or you, Äôll get a bug in the script.

There is also a change in the variable Allen under the AOT setup process provided in these collections that are presented in the 9th chapter of the script

Generation method. When you click the button, an operable edit script for the application's Visual Studio tool environment,

Open, allowing encoding classes to scriptmain directly. In this IDE, you can access all the advanced debugging policies, and break

Point and IntelliSense in the Visual Studio environment. If you create a variable containing a string "Hello

World, and set as shown in Figure 3-7, the following sample Script task MyValue A package that tells you how to write code, using

MyValue variables passed in:

Publicvoid Main ()
{
    if (Dts.Variables.Contains ("User::myvalue"))
     {
        System.Windows.Forms.MessageBox.Show ("myvalue=" + Dts.variables
["User::myvalue"]. Value.tostring ());
   }
 
    dts.taskresult = (int) scriptresults.success;
}
 
vbnet Code:
publicsub Main ()
    If Dts.Variables.Contains ("user::myvalue") = Truethen
        System.Windows.Forms.MessageBox.Show ("myvalue=" & Dts.variables
("User::myvalue"). Value.tostring ())
    EndIf
 
    dts.taskresult = Scriptresults.success
Endsub