Field Names Must Be Unique Within Table Issues

[greend21]

Would anyone know why I am receiving the error that field names must be unique within a table for the below part of my load?

CashAging:

SQL SELECT ReportDate AS [Report Date],

ReceiptStatus,

ReceiptType,

1DayCnt,

1DayAmt,

2DayCnt,

2DayAmt,

3DayCnt,

3DayAmt,

3PlusDayCnt,

3PlusDayAmt

FROM CSSC_Sequence_SIT.dbo.rptCashMaster

;

[greend21]

SSMS actually didn't even give me an error so I never noticed. When I look at the results I do notice now that the numbers are removed from the front of each column name.

[sunny_talwar]

good find