laddu4700 (9/16/2010)
I am trying to export the SQL Server 2005 database tables(10) to csv files.But some of the tables columns data have NULL values. I need to replace the NULL values with empty space. Easy way to find and replace in csv file.
I tried to write the T-sql statement using ISNULL function. But I could see 0 in NULL place.
Is there any way in SSIS where I can get it done? Appriciate your help.
You'll need to convert all numerics to strings if you want ISNULL(somenumber,'') to actually convert to an empty space.
--Jeff Moden
Change is inevitable... Change for the better is not.