Hi All,
I have a huge Table with so many fields. I am trying to dump its data into Excel from OLE DB Source to Excel Destination. When run, it issues this Error: [Excel Destination [2]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x00040EDA. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80040E21 Description: "Numeric field overflow.".
Apparently there would be some problem with datatype in the source data. but it doesn't say which field is cause of the error. As I have tens of fields in the table finding the infected column would be a real pain this way. Is there any way that I can get to the field name directly through SSIS?
Any help would be considerably appreciated