Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4453
  • Last Modified:

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.
0
ohemaa
Asked:
ohemaa
1 Solution
 
PedroCGDCommented:
if you attach here the ssis package and excel file I can try to help
(rename the dtsx file to txt)´
Regards
0
 
ohemaaAuthor Commented:
Needed to change source description to Ntext
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now