How to convert Null values to empty string in dest. table

Last Post 06 Mar 2006 07:43 AM by robertmazzo. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
robertmazzo
New Member
New Member

--
06 Mar 2006 06:50 AM
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
robertmazzo
New Member
New Member

--
06 Mar 2006 07:43 AM
Excellent point ! I had forgotten to set the default values.
Thank you,
Bob


Acceptable Use Policy
---