SSIS script task

  • hi

    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


    any ideas?



    Public Sub Main()
    Dim WH_STR As String
    WH_STR = Dts.Variables("User::WH").Value.ToString()
    Dts.TaskResult = Dts.Results.Success
    End Sub

    End Class

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply