question

Debasish avatar image
Debasish asked

datatype problem

Hi, I have a table in sql 2005 with column lastnamen varchar(50)(Problem with this column).I have one application which will upload data from Access to this table. In Access this field is text 100. Normally this field store english data. But for few cases it store unicode data. For this cases it throws following error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Through Import wizard there is no problem. Can anybody help me on this error.
sql-server-2005microsoft-accessdatatypes
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Håkan Winther avatar image
Håkan Winther answered
You should make sure that you have correct datatypes. It is not possible to store 100 characters in a varchar(50) and you may also need to use nvarchar(100) to be able to store unicode data (double byte character data). I am not sure about Access, but if you only can save 50 characters when you are entering unicode datam then you can use nvarchar(50).
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

hi, in access this values length is 3.i know if i use nvarchar then problem will be solved.but i can't change datatype.if it is varchar then also it should store the data.I have already mention thet in import export wizrad it is ok
0 Likes 0 ·
I guess that when you use the wizard it creates a conversion for you, but when you try to to it "manually" you need to specify convert or cast. If you save the SSIS package created by the wizard, then you can open the SSIS package to see how it is done.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.