August 19, 2008 at 10:53 am
hi,
I have two columns with data type unicode text stream [DT_NTEXT] in excel. in database i have varchar data type for both columns.
when i convert them to text stream[dt_text] i still get this error. can anyone help please..
[OLE DB Destination [20]] 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 Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
August 20, 2008 at 2:46 am
Anyone on this please?????????
August 20, 2008 at 3:37 am
It's weird that it is coming back as NText. What are the values in the first row of the document? Should normally come back as unicode. (DT_WSTR)
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 4:58 am
it is text in excel. anyway solved it by changing data type in db to text 😀
August 20, 2008 at 5:02 am
noooooooooo that's hardley a solution. You just scrwed up the destination to match the source.
Rather fix the problem.
Does it happen with a different spreadsheet?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 20, 2008 at 5:34 am
ok, i thought it would be fine as the distination seems to be correct data.
this happens only to one excel, I am wondering if it is because of large amount of charecters per row.
otherwise the format of column seems to be set to general.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply