Listing 1: Default Script in the VSA Window

'BEGIN COMMENT
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.
'END COMMENT

'BEGIN CALLOUT A
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
'END CALLOUT A

'BEGIN CALLOUT B
Public Class ScriptMain
'END CALLOUT B

'BEGIN COMMENT
	' The execution engine calls this method when the task executes.
	' To access the object model, use the Dts object. Connections, variables, events,
	' and logging features are available as static members of the Dts class.
	' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
	' 
	' To open Code and Text Editor Help, press F1.
	' To open Object Browser, press Ctrl+Alt+J.
'END COMMENT

'BEGIN CALLOUT C
	Public Sub Main()
'END CALLOUT C
'BEGIN COMMENT
		'
		' Add your code here
		'
'END COMMENT
'BEGIN CALLOUT D
		Dts.TaskResult = Dts.Results.Success
'END CALLOUT D
	End Sub

End Class




1