Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

error 0x80040E21 "Multiple-step OLE DB operation generated errors...." Expand / Collapse
Author
Message
Posted Thursday, August 23, 2012 6:26 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
Same error here... very odd
OLE DB Source [11]] 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 11.0"
Hresult: 0x80040E21
Description: "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done.".
Will try rebooting the machine, because according to the IDE, no errors occur but obviously during the processing an error does occur but the IDE ignores it. Question is, why does it do that?

In my package, which ran fine in 2008, I take two columns, separate them with a comma and delimit them with a pipe. I place this string into a text file. The best I can figure it that the comma and the pipe together violate some sort of ANSI7 rule and cause unicode to come into play inside the 2012 IDE.

Ideas?


Jamie
Post #1349408
Posted Thursday, August 23, 2012 7:33 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 5:43 PM
Points: 71, Visits: 480
One way to be certain that SSIS will process data elements with exactly the data type you want is to make all the explicit conversions yourself from a "type controlled" import.

For example, read all the data in as text from Excel. Then immediately convert each data element explicitly (perhaps to brand new columns) as desired in your data flow. Then you can be sure that all downstream tasks or components you apply to the data flow will use exactly the data types you expect.




Post #1349415
Posted Friday, August 24, 2012 5:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
That's a good idea. Will give it a shot.

Jamie
Post #1349593
Posted Monday, March 18, 2013 12:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 9:47 PM
Points: 19, Visits: 92
Hi the below steps might help to solve issue more quickly.

1.Use the OLE DB Destination.
2.Use the "Table or View - fast load " as data access mode.
3.Check “Keep nulls” and “Table lock” property, and keep the other properties unchecked.
4.Map the new converted columns to SQL destination table columns.


Thanks,
Hemanth(CTS)
Post #1432084
Posted Monday, August 19, 2013 4:20 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 31, 2014 7:16 AM
Points: 90, Visits: 163
this worked for Me but didnt understand what was the problem
Was anyone able to find it to avoid this again


------------------------------------------------------------------------------------

Ashish

The journey to knowledge is knowledge of journey

Why so serious
Post #1485714
Posted Wednesday, August 28, 2013 5:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 27, 2014 12:28 AM
Points: 1, Visits: 10
Hi khemu8290,

The Solution has worked great..I stucked with this issue from last so many days. Thanks for the awesome solution.
Post #1489138
Posted Wednesday, August 28, 2013 6:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 26, 2014 9:47 PM
Points: 19, Visits: 92
Welcome Bro :)
Post #1489157
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse