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