Ok it's all making sense now. Thanks GSquared, Craig, and Lowell for the replies and suggestions.

Huh... The 2 columns I noticed the problem with, the PREFIX and SUFFIX, are char(8). The others are varchar.

I still don't understand why, if the columns contain...

Stamey (10/11/2010)

Setting up error handling is is a good practice also, if you want the package to be able to continue running after it encounters an error, such as...

Alvin,

I started off the project using the import wizard, and nvarchar is what it used. I changed it to nchar, but it looks like I will be changing it...

Thanks GSquared,

Could you tell me, how do the rows from the error table get back into the correct table? Do you simply write scripts to run outside SSIS to...