I am using SSIS to output results from a query to a flat file. I need the results to output as: The Help Guru|7.28||||||||.
Instead, the output is : The Self Help Guru|7.28|
How do I get my data to output as The Help Guru|7.28||||||||?
It looks like my blank fields are not being displayed with empty pipes.