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").CustomTas k

DTS.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTas k.connectionID = 4
..
..
..

End Function

but how to retrieve the value from transformation in activex?
http://img.photobucket.com/albums/v2...x/288162fd.jpg

Hello Sphenixs (AT) gmail (DOT) com,


try this script


'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()


dim myPkg 'As Package
dim myTask 'As Task
dim myCustomTask 'As CustomTask
dim myTransformation 'As Transformation
dim myColumn 'As DestinationColumn
dim myDataType 'As DataType




set myPkg = DTSGlobalVariables.Parent
set myTask = myPkg.Tasks("DTSTask_DTSDataPumpTask_1")
set myCustomTask = myTask.CustomTask
set myTransformation = myCustomTask.Transformations("DTSTransformation__1 ")
set myColumn = myTransformation.DestinationColumns("Tx_DT")


''''''' You get it ! ''''''''
myDataType = myColumn.DataType



set myColumn = nothing
set myTransformation = nothing
set myCustomTask = nothing
set myTask = nothing
set myPkg = nothing


Main = DTSTaskExecResult_Success
End Function

Bye

Woot, u are so helpful
I'll try once I get back into my office

Google Roxz