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

You get this error when the data that you're trying to insert is larger than the max. column size. You can use the following script to demonstrate this:

create table x (c char(5))
go
insert into x (c) values ('1234567899')

If you issue SET ANSI_WARNINGS OFF, SQL Server will not throw an error. Instead, the data will be truncated to the size of the column.

-Mike