I am transferring data to a sql table using DTS packages. The new table table contains about 10 extra columns. When I execute the DTS package, Sql replaces the new column values with NULL. If my new table has a Null contstraint, I get an error stating that Null values cannot be inserted.
Of course I can change the column contraints to accept nulls, but isn't there a better way to handle this (like converting to an empty string or a zero value for new columns) ?