Script Component And Post Execute Method - Help Please!

Hello, I have been wrestling with a script component and the post execute method. I have obtained some bits of information from the discussions from previous posting - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=97494&SiteID=1 and have also tried the suggested approaches. Being new to SSIS and .NET as well I am certain that I do not see the entire picture yet.

I have a Read/Write variable that I am assigning a value to. The variable is then processed through a derived column and subsequently used by a flat file.

I have eliminated the following exception thus far.

Error: 0xC0047062 at Data Flow Task, Script Component [518]: Microsoft.SqlServer.Dts.Pipeline.ReadWriteVariablesNotAvailableException: The collection of variables locked for read and write access is not available outside of PostExecute.

But, my flat file does not contain in it the assigned values to the variable. A brief summary of the process follows:


OLE DB SOURCE ===> followed by the Script Component ===> followed by the Derived Columns ===> followed by the flat file.

Sample Script is:

Public Class ScriptMain
Inherits UserComponent

Public NewName As String

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
'
' Add your code here
'
NewName = Row.BPNM

Me.Variables.ShortName = NewName

End Sub

Public Overrides Sub PostExecute()

MsgBox("In first script...")
Me.Variables.ShortName = NewName
MsgBox("variable is " & Me.Variables.ShortName)
End Sub


Question. What am I not doing that prevents me from extracting and passing the respective values to the derived column for each of the rows processed. When I try to assign the value of NewName to the Short Name variable, In red above, I encounter the post execute exception, again.

What code should I have in place to insure that I am not trying to reference the variable on a PostExecute within the normal process of the script component? Any guidance would be immensly appreciated.

Help Please!!