I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (
right click DB > Tasks > Import Data)
- DB1 is the source DB, it has a collation set to
- DB2 is the destiantion DB, it has a collation of
I can run through the wizard, using a query of "select * from myTable". That creates the table on my destination DB no problem, I don't save this.
I run the wizard a second time, so I can go into the mappings and select "delete existing rows" (since I can't do this first time round). Then at the end I save it, save it on the SQL server.
I get the following errors :
"MyColumn" cannot be processed because more than one code page (1251 and 1252) are specified for it. (SQL Server Import and Export Wizard)
I have checked on MSDN and found this article suggesting that difference in collation types could cause some issues with data type conversions
It was suggested to use nvarchars, so I have started again making sure the table on my destination DB are using nvarchars, but I'm now getting the following error
Data Flow Task: The product level is insufficient for component "Data Conversion 1" (197).
Changing my destination DB collation to cyrillic is not an option, since later on I will be importing from other DBs so may run back into this issue.
Is there anything I can do to work around this issue? I hope I have provided enough info