If your source is a query you could use the ISNULL function on the desired fields.
Brian Freeman

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Monday, December 29, 2003 11: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