asked on
Why is there a Comma being input in the TXT output file?
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),CHECKD
WHEN 'O' THEN '' WHEN 'V' THEN 'C' END + '' as Val
FROM dbo.CHK
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 ,
00000123456789002000000002
Can anyone tell me why this is happening and how I can fix it?
SELECT '00000123456789002'+RIGHT ('00000000' + LTRIM(CAST(CHECKNO AS VARCHAR(20))), 15)
+ CONVERT(varchar(10),CHECKD
WHEN 'O' THEN '' WHEN 'V' THEN 'C' END + '' as Val
FROM dbo.CHK
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 ,
00000123456789002000000002
Can anyone tell me why this is happening and how I can fix it?
Microsoft SQL Server 2008SSRSMicrosoft SQL Server 2005
Last Comment
Simone B
ASKER
So if I ran that query it would export it to a Text?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I'll do that now Buttercup, I think you're dead on!
ASKER
That was it, Thanks a ton!
Excellent! Happy to help.
You could manually try to export something like :
exec master..xp_cmdshell N'sqlcmd -E -Q"set nocount on; SELECT ''00000123456789002''+RIGH
FROM dbo.CHK
WHERE checkdate BETWEEN ''03/14/12'' and ''03/14/12'' and bankid=''MYBANK''and ISNUMERIC(checkno)=1;" -W -o"c:\output.txt"'