Sorry for the cross post.  I originally posted this in the wrong NG.

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.