DTS and Null Values
Posted on 2005-05-06
I have a DTS package set up that is doing sevral equations. I use CASE statements in a sub select and then have to Sum() some of the variables in the outer select (its kinda large and bulky so i dont want to post it unless i have to).
I have some values where part of the equation is Null, thus giving me a Null result, which is desired. However, when i export the Null value i want something to show up in its place, weather it is a "Null" or a "0" i really don't care, i just dont want the absence of anything (which is what im getting now).
I cant use a case statement in the SQL because i am already Sum()'ing columns for my results. I have messed around with the "Keep Null Values" option in DTS but weather it is checked or not i get blanks where the Null's are.
I am exporting to a fixed width text file.