I am getting below error; what could be the reason?
The input is valid adn works good if I give to a multicast for test. But I get below error when I use OLEDB Destination ("table or view fast load") as my target.
Note: Columns mappings are done auto by SSIS and All looks good as my source and destination are having same names as well.
[Stage - Issue ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step
OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
[Stage - Issue ] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "Stage - Issue" (33923) failed the pre-execute phase and returned error code 0xC0202025.
View Complete Post