Link to home
Start Free TrialLog in
Avatar of ohemaa
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.
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

if you attach here the ssis package and excel file I can try to help
(rename the dtsx file to txt)´
Regards
ASKER CERTIFIED SOLUTION
Avatar of ohemaa
ohemaa

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial