SSIS Documentation

Contents

• ExpressionsWorkflowFinal
  • Script Task
  • Exec SQL Count
  • Send Mail Task
  • Final Task
  • Connections
    • localhost.AdventureWorks
    • SMTP Server

ExpressionsWorkflowFinal Version: 1.0.18

Property	Value
PackageFormatVersion	2
VersionComments
CreatorName	VPCWINXPPRO\Administrator
CreatorComputerName	VPCWINXPPRO
CreationDate	9/5/2005 4:40:00 PM
PackageType	DTS Designer 90
ProtectionLevel	1
MaxConcurrentExecutables	-1
PackagePriorityClass	0
EnableConfig
CheckpointFileName
SaveCheckpoints
CheckpointUsage	0
SuppressConfigurationWarnings
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	English - United Kingdom
TransactionOption	Supported
DelayValidation
ObjectName	ExpressionsWorkflowFinal
Description
DisableEventHandlers
RowCount	0
TableNameVariable	Production.Product
LoggingMode	Use Parent Setting

Connections

• OLEDB: localhost.AdventureWorks

Property	Value
Retain
ConnectionString	Data Source=localhost;Initial Catalog=AdventureWorks;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;

• SMTP: SMTP Server

Event Handlers

Property	Value
EventID	0
EventName	OnError
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
Description
Propagate	16316
LoggingMode	Use Parent Setting

Script Task

(Script Task)

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Script Task
Description	Script Task
DisableEventHandlers
LoggingMode	Use Parent Setting
Script Project
Name	ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e
Language	Microsoft Visual Basic .NET
EntryPoint	ScriptMain
SaveBinaries	False
ReadOnlyVariables	SourceName,ErrorDescription
ReadWriteVariables	Cancel
Item: dts://Scripts/ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e/ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e.vsaproj <VisualStudioProject> <VisualBasic Version = "8.0.50215.44" MVID = "{00000000-0000-0000-0000-000000000000}" ProjectType = "Local" ProductVersion = "8.0.50215" SchemaVersion = "2.0" > <Build> <Settings DefaultNamespace = "ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e" OptionCompare = "0" OptionExplicit = "1" OptionStrict = "1" ProjectName = "ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e" ReferencePath = "C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\9.0.242.0__89845dcd8080cc91\;C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\" TreatWarningsAsErrors = "false" WarningLevel = "1" RootNamespace = "ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e" > <Config Name = "Debug" DefineConstants = "" DefineDebug = "true" DefineTrace = "true" DebugSymbols = "true" RemoveIntegerChecks = "false" /> </Settings> <References> <Reference Name = "System" AssemblyName = "System" /> <Reference Name = "System.Data" AssemblyName = "System.Data" /> <Reference Name = "Microsoft.SqlServer.ScriptTask" AssemblyName = "Microsoft.SqlServer.ScriptTask" /> <Reference Name = "Microsoft.SqlServer.ManagedDTS" AssemblyName = "Microsoft.SqlServer.ManagedDTS" /> </References> <Imports> <Import Namespace = "Microsoft.VisualBasic" /> </Imports> </Build> <Files> <Include> <File RelPath = "ScriptMain" BuildAction = "Compile" ItemType = "2" /> <VSAAppGlobal VSAAppGlobalName = "Dts" ItemType = "1" VSAAppGlobalType = "Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel" /> </Include> </Files> <Folders> <Include/> </Folders> </VisualBasic> </VisualStudioProject> Item: dts://Scripts/ScriptTask_16a09e950fe74e1cb0830daa1c2cd62e/ScriptMain.vsaitem ' Microsoft Data Transformation Services (DTS) Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Public Class ScriptMain ' The DTS execution engine calls this method when the task executes. ' To access the DTS 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. Public Sub Main() If MsgBox("Source: " + Dts.Variables("SourceName").Value.ToString() + Environment.NewLine + _ "Message: " + Dts.Variables("ErrorDescription").Value.ToString() + Environment.NewLine + _ Environment.NewLine + _ "Cancel package?", MsgBoxStyle.YesNo, "Doh!") = MsgBoxResult.Yes Then Dts.Variables("Cancel").Value = True End If Dts.TaskResult = Dts.Results.Success End Sub End Class

Exec SQL Count

(Execute SQL Task)

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Exec SQL Count
Description	Execute SQL Task
DisableEventHandlers
LoggingMode	Use Parent Setting

Send Mail Task

(Send Mail Task)

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Send Mail Task
Description	Send Mail Task
DisableEventHandlers
SendMailMessageVariable	The table count query for Production.Product returned 0 rows.
LoggingMode	Use Parent Setting

Final Task

(Final Task)

Property	Value
ExecutionLocation	0
ExecutionAddress
TaskContact
ForceExecValue
ExecValue	0
ForceExecutionResult	-1
Disabled
FailPackageOnFailure
FailParentOnFailure
MaxErrorCount	1
ISOLevel	1048576
LocaleID	Default
TransactionOption	Supported
DelayValidation
ObjectName	Final Task
Description	Final Task
DisableEventHandlers
LoggingMode	Use Parent Setting