i want to pass an object variable to a string variable so that i can use the string variable to determine the location i will write a file to.
i am using a script task and below is the contents, but it does not seem to pass anything to the Str variable
i have checked break points and the variable is always blank, i know the object variable is getting assigned as i am writing to the file the correct details
Public Sub Main()
Dim WH_STR As String
WH_STR = Dts.Variables("User::WH").Value.ToString()
Dts.TaskResult = Dts.Results.Success