Why is there a Comma being input in the TXT output file?
Posted on 2012-03-19
I've created a DTSx Package that runs the following Query:
SELECT '00000123456789002'+RIGHT ('00000000' + LTRIM(CAST(CHECKNO AS VARCHAR(20))), 15)
+ CONVERT(varchar(10),CHECKDT, 112)+ RIGHT ('0000000' + REPLACE (CAST(checknet AS VARCHAR(20)), '.', ''), 10)+CASE(ckstatus)
WHEN 'O' THEN '' WHEN 'V' THEN 'C' END + '' as Val
WHERE checkdate BETWEEN '03/14/12' and '03/14/12' and bankid='MYBANK'and ISNUMERIC(checkno)=1
The Results are put into a Txt File
At the end of the results it's adding a ,
Can anyone tell me why this is happening and how I can fix it?