Error when importing data
Posted on 2011-09-04
I have a database called SUNDB running in SQL Server 2005. I also have a job running (saved as a SSIS package) that imports data from a couple of tables into another database called SUNREP.
Recently, we had called in the vendor to change theSUNDB database collation to Cyrillic_General (it was originally Latin General). He ended up creating a new database all together with the new collation.
The problem now is that my job is failing. I tried recreating the job but to no success. The error that I'm getting is:
The column ####### cannot be processed because more than one code page (1251 and 1252) are specified for it.
At first i thought it was a problem with the SSIS package, so then i just tried creating a a normal "Import Data" task using the wizard and that failed too.
I then tried changing the collation of the SUNREP database to match the same Cyrillic General collation of SUNDB, by just changing it in the options, but this didn't work either.
Any ideas on this? At this stage i don't really want to create a SSIS package, i just want the database import to work as getting the data from SUN to SUNREP is rather urgent.
I'm no expert at SQL, i just make sure the database is backedup and the jobs run, so please use layman terms if you don't mind :)