I am trying to transfer one SQL Server database into a new one. The old one
supported nulls on every colum, and the new one, well, doesn't.

In order to use DTS, do I have to make every transformation a ActiveX script
that checks for nulls and uses the default value for the column if it finds
one in the sporce column? Or is there a global way to do that?

Thanks!

There is no Global way of doing this in DTS i.e. replacing all nulls in all
columns with a value as what would that value be? The same in every column
of every table?

Unfortunately you will have to do this the "Long Hand" way.




"bill (AT) sempf (DOT) net.nospam" <billsempfnetnospam (AT) discussions (DOT) microsoft.com> wrote
in message news06D241A-9F9F-4E87-82F0-A4C7F5EC6326 (AT) microsoft (DOT) com...

Hi, Allan.

The value would be the default value for the column, just like if I inserted
a row any other way. If I use the longhand method (checking for nulls and
skipping the value if it is null) then that default value is what is
populated. It just makes sense that there should be a default mechanism for
handling that.

If there isn't ... well ... that's just silly!

S

"Allan Mitchell" wrote: