> This is the code where I retrieve the value from the task
>
> '**********************************************************************
> '  Visual Basic ActiveX Script
> '************************************************************************
>
> Function Main()
>
> Dim DTS, ExecSQL, SQLStatement
>   Set DTS = DTSGLOBALVARIABLES.Parent
>
>   Set ExecSQL = DTS.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTask
>
>   DTS.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTask.connectionID = 4
> .
> .
> .
>
> End Function
>
> but how to retrieve the value from transformation in activex?
> http://img.photobucket.com/albums/v220/sphenix/288162fd.jpg