[OLE DB Destination [14]] 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 Server Native Client 10.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Regards, Vipin jhaThankx & regards, Vipin jha MCP

Is that the only error that you get? ps: your caps lock is broken MCTS, MCITP - Please mark posts as answered where appropriate.

check your connectionstring. maybe something wrong there. regards joon

[OLE DB Destination [14]] 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 Server Native Client 10.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". [OLE DB Destination [14]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid. [SSIS.Pipeline] Error: component "OLE DB Destination" (14) failed the pre-execute phase and returned error code 0xC0202025.Thankx & regards, Vipin jha MCP

How did you configure the OLE DB Destination?MCTS, MCITP - Please mark posts as answered where appropriate.

Hi Vipin jha, It seems you have a data quality issue, how do you configured in the OLE DB Destination? For more information about importing data from Excel to SQL Server, please refer to the KB: http://support.microsoft.com/kb/321686 Please feel free to ask if you have any question. Thanks, Eileen