View Single Post
  #1 (permalink)  
Old April 23rd, 2011, 07:40 PM
Nachikethm Nachikethm is offline
Registered User
 
Join Date: Apr 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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