WHAT'S HOT
Prev | Current Page 182 | Next

Jayaram Krishnaswamy

"Beginners Guide to SQL Server Integration Services Using Visual Studio 2005"

This window
is common to all tasks we are going to test in this package. You can provide a Name
and a Description for this task.
1. Provide a Name and Description for the task, as shown in the screenshot, by
typing them in the editor.
???
???
???
Chapter 19
[ 275 ]
2. Click on the Script list item on the left of the Script Task Editor.
This will open the Script item details on the right-hand side of the Script
Task Editor, as shown in the next screenshot.
There are five Script-related line items:
Script Language
Well, there is only one Script Language, Microsoft VB.NET.
PrecompileScriptIntoBinaryCode
The default is true and in all the examples in this chapter it is set to false either
in this Script Task Editor or the Properties window of this Task Component.
With this set to False, the code will be compiled just before the package (task)
is executed. With the other option set to true, the code will be compiled and
stored as a Base64 code in the package.
Entry Point
This is where the script loads into the engine. ScriptMain is the name of the
VB Class file.
ReadOnlyVariables
??? ???
???
???
Package with a Script Task
[ 276 ]
The variable(s) are read only as the line item suggests.
ReadWriteVariables
The variable(s) are read/write as the line item suggests.
The button at the bottom, Design Script??¦ opens a new Script editor interface
where most of the code is created.
3. Change the PrecompileScriptIntoBinaryCode line item to false and click on
the Design Script??¦ button.


Pages:
170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194
payday loans lampy wpuszczane meble Linki Sponsorowane Google Adwords Projekty garaży