Multiple-step OLE DB operation generated errors.
Hello, Source : XML Destination: SQL Server 2008 R2 I used data conversion transformation for changing data types in SSIS. I am getting the error as below. [OLE DB Destination [10]] 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.". i strucked with this error please put me in correct way. Thanks,
January 15th, 2012 3:42am

You might be choose wrong data type ... Why don't you dump full data set into work / temp table from that you can cast with T-SQL to pull/ push onto main table. http://uk.linkedin.com/in/ramjaddu
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2012 6:58am

I would check the data type of the inputs are you mapping a Unicode (WSTR) input into a varchar column in SQL Server? Or ASCII (DST) into an nvarchar column? Many if not most numeric conversions won't work either.Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008
January 15th, 2012 7:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics