Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Multiple-step OLE DB operation generated errors

Author  Topic 

learntsql

524 Posts

Posted - 2010-03-05 : 02:05:39
Hi All,
When I am trying to load Excel sheet data into SQL Server table getting following error.

[OLE DB Destination [14]] Error: 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.".

plz. guide me.
TIA.
   

- Advertisement -