The error is "String or binary data would be truncated. The statement has been terminated."

I think this error is being generated because there are fewer columns in the target table and Sql is trying to store into a column that doesn't exist.

Since syscolumns shows the correct structure there must be another table that is being used and it is this table that is being corrupted. Just a guess.

Mike, I appreciate you taking the time to look into this with me.

Keith