I am trying to set the value of the variable User::ErrorMessage dynamically
using the Script Task. I would like to construct an error message containing
carriage returns for use with a Send Mail Task.

ReadOnlyVariables :
User:WAuditStepDescription,System::StartTime,Sys tem::EventHandlerStartTime,System::PackageName

ReadWriteVariables :
User::ErrorMessage

Script Code:

Public Sub Main()

Dts.Variables("User::ErrorMessage").Value = "Package: " &
Convert.ToString(Dts.Variables("System::PackageNam e")) & Chr(13) & "Internal
Step Name"
'
Dts.TaskResult = Dts.Results.Success
End Sub

After executing the Script Task, the value of User::ErrorMessage is

"Package: Microsoft.SqlServer.Dts.Runtime.Variable\rInternal Step Name"

What am I doing wrong?

Thanks!

The following example works for me

Public Sub Main()

'

Dts.Variables.Item("sV").Value = "Hello" & Chr(13) & Chr(10) & "World"

MsgBox(Dts.Variables.Item("sV").Value)

'

Dts.TaskResult = Dts.Results.Success

End Sub



Allan




"Jeanine Carroll" <JeanineCarroll (AT) discussions (DOT) microsoft.com> wrote in
message news:A7BC8D9D-5FA1-4128-BF07-752541DB3AA5 (AT) microsoft (DOT) com...