How to access a variable and foward it down the Data Flow in SSIS 2005

[huertj]

Hello everyone. I h've been trying for the last week to access a variable in my SSIS package and foward it down to a Data Conversion Item. I've read that I could use a Derived Column or a Script Component Item but I have not had any luck. When I use the Script Componet I am able to test the variable value by adding the code Msgbox(Me.Variables.WMWeekNbr) in the method CreateNewOutputRows in the ScriptMain class. I see the message box with value but it doesn't foward to the data conversion item. I did add the variable to ReadOnlyVariables property. I also created a output columns on the script object. Im basically trying to create a C# application that will take a value and pass it to the SQL SSIS package which will delete values from the database. Thanks :doh: