Case Study Process Package
Hi,
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.
SQL Query:
SELECT h.ImportType,
BankBatchDtlID,
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
Thanks
Nachi
Last edited by Nachikethm; April 23rd, 2011 at 07:50 PM..
Reason: add more details
|