ToString)
Dts.TaskResult = Dts.Results.Success
End Sub
The code is very simple. The For??¦Next loop steps through 0 to 15 and included
in the loop is a string builder variable sb, which adds a number followed
by a "|" symbol. The If...Else...End...If statement takes care of removing "|"
from the end.
In order to use the StringBuilder, a class that helps in building strings, we
have added an extra imports statement (imports System.text) to the default
imports statement that you find in the Microsoft Visual Studio Editor's
ScriptMain as shown in the next figure a la Intellisense.
This will give access to the methods and properties of this class, as shown in
the object browser.
Package with a Script Task
[ 282 ]
4. After adding the code as described, click on the OK button on the Script
Task Editor window to close the window.
5. Build the project and execute the "String Builder Task" Script Task.
6. The program runs and the Script Task component turns green and soon you
will see the Script Task message window pop-up, as shown.
Retrieve Data from a Database Table in the
SQL Server 2005
1. Repeat the previous steps to configure a new Script Task whose Name is "Get
Employees Task" with the description "Get last names from MyNorthwind
database's Employees table".
2. Change the PrecompileScriptIntoBinaryCode line item to false in the Script
list item of the Script Task Editor, and click on the Design Script??¦ button.
3. In the Microsoft Visual Studio for Applications, type in the following code
in the appropriate location, as shown in the following paragraph.
Pages:
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198