"Asim Siddiqui" wrote:

> Hi,
>
> I would really appreciate if anyone of you can help me. I am new to the DTS
> and working on multiple column lookup under ActiveX script. I am using SQL
> Server 2000.
>
> Lookup Query:
> SELECT STATUS_DATE,STATUS_CODE,DELIVERY_DATE
> FROM PRODUCT_ORDER
> WHERE (PRODUCT_ORDER_ID = ?)
>
> The Transformation is
> Function Main()
> aProduct =
> DTSLookups("ProductPO").Execute(DTSSource("ORDER_NUMBER"))
> POStatusDate = aProduct(0)
> POStatusCode = aProduct(1)
> PODeliveryDate = aProduct(2)
>
> DTSDestination("PO_NUMBER") = DTSSource("ORDER_NUMBER")
> DTSDestination("PO_DATE") = aProduct(0)
> DTSDestination("PO_STATUS") = aProduct(1)
> DTSDestination("PO_DELIVERY_DATE") = aProduct(2)
> Main = DTSTransformStat_OK
> End Function
>
> When i run this transformation I am getting the following error:
> The number of failing rows exceeds the maximum specified.
> Error Code: 0
> Error Source: Microsoft VBScript runtime error
> Error Description: Type Mismatch: 'aProduct'
> Error on Line 7
>
> Thanks.