SSIS & Code Pages..

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

 

[Sylvain Lafontaine]

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

 

[Bob McClellan]

Thanks Sylvain.

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)

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.