New columns in destination table are replaced with NULL ?

• bob mazzo

  SSCommitted

  Points: 1684

  More actions

  March 6, 2006 at 8:53 am

  #76498

  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) ?

  thanks,

  Bob

• bob mazzo

  SSCommitted

  Points: 1684

  More actions

  March 6, 2006 at 9:46 am

  #624953

  I forgot to set the default values on those new columns.

  Thanks anyway folks !