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.
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).
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.
