SSIS script task

• dopydb

  SSCertifiable

  Points: 6687

  More actions

  April 11, 2019 at 2:22 pm

  #3125668

  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?

   

  mal

  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