How to foward a variable to a data conversion item

• huertj

  Grasshopper

  Points: 19

  More actions

  November 19, 2007 at 10:58 am

  #176914

  Hello everyone

  I have been trying to access a variable in my SSIS package and pass it down a data flow for a week now I have not been successful so I figured I would ask you guys/gals.

  Im using a script component and I added my WMWeekNbr variable to the ReadONlyVariables. I also added a output column and wrote the test MsgBox(Me.Variables.WMWeekNbr) in my ScriptMain:CreatNewOutputRows which works I see the message box with the assigned value but I cant seem to pass it down the data flow as an output. Im try to pass it to a data conversion item.

  I basally created a c# application that will pass a value to the SSIS package and then join to a table to get the ID and delete the values on another table base on the value that was passed in.

  Thanks

• Dr. John Tunnicliffe

  Right there with Babe

  Points: 782

  More actions

  November 19, 2007 at 1:26 pm

  #752443

  Did you call the AddRow() method on your output buffer? If not, you will not get any output from your script component.

• huertj

  Grasshopper

  Points: 19

  More actions

  November 19, 2007 at 4:46 pm

  #752485

  Yes! thanks it worked:). Believe or not but these two lines where commented out on my code :w00t:

  WMWeekNbrBuffer.AddRow()

  WMWeekNbrBuffer.WMWeekNbr = Ctype(Me.Variables.WMWeekNbr, String)

  Thanks again Dr.