ohemaa
asked on
OLE destination errors in SSIS
I am migrated a DTS package from SSIS. I get this error
[OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E21.
[OLE DB Destination [55]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "OLE DB Destination" (55) failed the pre-execute phase and returned error code 0xC0202025.
I deleted the recreated the OLe DB Source and destination. read articles on google nothing helped.
The package just queries a table and output data to different sheets in excel. I have similar packages working fine.
Any inputs?
[OLE DB Destination [323]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
[OLE DB Destination [323]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "OLE DB Destination" (323) failed the pre-execute phase and returned error code 0xC0202025.
[OLE DB Destination [55]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040E21.
[OLE DB Destination [55]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "OLE DB Destination" (55) failed the pre-execute phase and returned error code 0xC0202025.
I deleted the recreated the OLe DB Source and destination. read articles on google nothing helped.
The package just queries a table and output data to different sheets in excel. I have similar packages working fine.
Any inputs?
[OLE DB Destination [323]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
[OLE DB Destination [323]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[DTS.Pipeline] Error: component "OLE DB Destination" (323) failed the pre-execute phase and returned error code 0xC0202025.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ohemaa, can you help please: https://www.experts-exchange.com/questions/26498315/SSIS-error.html?cid=1572&anchorAnswerId=33771239#a33771239
(rename the dtsx file to txt)´
Regards