Solved

Error when importing data

Posted on 2011-09-04
6
405 Views
Last Modified: 2012-05-12
Hi,

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

Best Regards,
CV
0
Comment
Question by:connelvalentine
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 29

Assisted Solution

by:sammySeltzer
sammySeltzer earned 250 total points
ID: 36480398
I think there is a feature called AlwaysUseDefaultCodePage

Try turning that from false to True and try again. Please see link below

http://blog.techno-tricks.com/?p=28
0
 

Author Comment

by:connelvalentine
ID: 36480405
But again, this seems to be a property that is set when creating SSIS packages. In my case, I'm just tring to accomplish a normal import data wizard task and it fails with this error.
0
 

Author Comment

by:connelvalentine
ID: 36483450
i've also seem to have come across another discovery. I tried creating a new database, and started importing the data from scratch. When the tables in the destination database doesn't exist, and the import job requires to create the table and then transfer the data, all seems fine.

but if i run the import job AGAIN, when the table already exists in the destination database, the same error above occurs.
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

Assisted Solution

by:Pit Z
Pit Z earned 250 total points
ID: 36484825
check all varchar column colation and set all to only one
0
 

Accepted Solution

by:
connelvalentine earned 0 total points
ID: 36522967
well it turns out that i had to recreate the new database with the collation of the source database and redo the import jobs from scratch. thanks to. thanks to all for the help
0
 

Author Closing Comment

by:connelvalentine
ID: 36553449
answered partially
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question