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?