How to foward a variable to a data conversion item

  • 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

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

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

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