Yes, you have to do a transformation step and use VB to transform the
data for each field as desired.

Ken

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed]
Sent: Monday, December 29, 2003 8:23 AM
To: LazyDBA.com Discussion
Subject: DTS Job urgent

Hi All,
SQL Server 7
Is their anyway to replace null values in all the
fields being replicated to blanks in a DTS Job?


Waiting for reply
TIA
Adil

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page