October 6, 2011 at 1:32 pm
Hi ,
I have a situation in which , i need to transfer the sql data into Excel File. So I use the OLEDb Data Source then apply data Conversion tranformation to convert the data type from code to unicode string, and at last Excel destination .
I am able to transfer the table but there are some null values inside the Columns of sql table , which shows up as a blank in Excel File instead of Showing NULL.
so help me out ,I really appreciate it
thanks
October 6, 2011 at 1:33 pm
You could use Coalesce or IsNull in your query.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 6, 2011 at 1:37 pm
But there are like 50 columns inside the table so I have to use Coalesce for each Column
October 6, 2011 at 1:47 pm
If you want the word "NULL" instead of a null value, then yes, you'll need to do that for each column.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply