Hi
The DTS Task fails when trying to get multiple columns
The Task successfully works for single column

Here's the LookupQuery from Oracle

Select szname, szdescription
--------------------------------------------------------------

Here 's the ActiveX script

'************************************************* *********************
' Visual Basic Transformation Script
'************************************************* ***********************

' Copy each source column to the destination column
OptionExplicit
Function Main()
Dim networkinfo

DTSGlobalVariables("Name").Value = DTSSource("Name")

networkinfo =
DTSLookups("NetworkLookup").Execute(DTSGlobalVaria bles("Name").Value)

DTSDestination("LookupNetworkCode") = networkinfo(0)
DTSDestination("LookupNetworkDescription") =
networkinfo(1)

Main = DTSTransformStat_OK
End Function

------------------------------------------------------------------------------------------


Any help would be appreciated.

Thanx
Oichi