SSIS & Code Pages..

  • Thread starter Thread starter Bob McClellan
  • Start date Start date
B

Bob McClellan

I've been working on setting up a package to simply append data into a table
residing in a 2005 db.
(I've even tried importing the flat file from management studio)

I continue to get this error, regardless of how I structure the target
table.
[Flat File Source [1]] Error: Data conversion failed. The data conversion
for column "first_name" returned status
value 4 and status text "Text was truncated or one or more characters had
no match in the target code page.".

I feel the problem is in the "no match in the target code page"

If I go to an old box running SQL Server7, it imports with no problem.

Any advice on how to combat this would be very much appreciated.
Thanks in advance,
bob.
 
Use NVarchar instead of Varchar and you should be OK. If not, provide more
details.
 
Thanks Sylvain.


Sylvain Lafontaine said:
Use NVarchar instead of Varchar and you should be OK. If not, provide more
details.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


Bob McClellan said:
I've been working on setting up a package to simply append data into a
table residing in a 2005 db.
(I've even tried importing the flat file from management studio)

I continue to get this error, regardless of how I structure the target
table.
[Flat File Source [1]] Error: Data conversion failed. The data
conversion for column "first_name" returned status
value 4 and status text "Text was truncated or one or more characters
had no match in the target code page.".

I feel the problem is in the "no match in the target code page"

If I go to an old box running SQL Server7, it imports with no problem.

Any advice on how to combat this would be very much appreciated.
Thanks in advance,
bob.
Click to expand...
Click to expand...
 
Back
Top