Sphenixs@gmail.com wrote:
> 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