|
Home > Archive > MS SQL Server DTS > March 2006 > DTS - Multiple Column Lookup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS - Multiple Column Lookup
|
|
| Asim Siddiqui 2006-03-29, 1:29 pm |
| 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_C
ODE,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.
| |
| Asim Siddiqui 2006-03-30, 9:31 am |
| I am desparetely looking for the solution as I have already spent so much
time to find the solution ...Please help me!
"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_C
ODE,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.
>
|
|
|
|
|