Case Study Process Package
When I try run SSIS package it is complaining about column name "PaymentAmount" which is not present in the table "bankbatchdetail" can you please help me about it.
UPPER(RawInvoiceNbr) as RawInvoiceNbr,
PaymentAmount -- cant find this columnd and Book page nubmer:655
FROM bankbatchdetail d
INNER JOIN BANKBATCH h
ON h.bankbatchid = d.bankbatchid
WHERE matcheddate is null
AND RawInvoiceNbr is not null
AND RawInvoiceNbr <> ''
ORDER BY bankbatchdtlid
Last edited by Nachikethm; April 23rd, 2011 at 08:50 PM.
Reason: add more details