Hello,

I'd like to run mssql queries in a bash script with tsql command. Thats okay, i can connect and run manualy. I tried to save the result to a file with this script but no success.

> tsql -connection parameters- < tsql_input.sql > tsql_output.csv

where tsql_input.sql is :

select ... from .... ;

what's happening (so what is the expected result and what is the real result)?

Hello Pan64,

Thanks for the reply. After running the script above i got this in tsql_output.csv file :

locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "ISO-8859-1"
locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "ISO-8859-1"
1> 2> 3> 4> 5> 6> 7> 8>

If i run just the tsql to connect the server i got a "1>" prompt where i can send commands like select * from... and i got the results there. thats okay. I just unable to run it from a script.

I have a simple "select.. from.." query in tsql_input.sql file, and it's result i want to dump to the output file.

if I understand well you may need expect to do that.

As i see expect will be a good option, but finally i solved the problem with this way :

/usr/bin/tsql ...parameters.... < cmd > $tempfile

where cmd is

SELECT .... FROM ...
GO
EXIT

Hello gszabo,

I'm stuck with the exact same problem.

When I fire this command, I don't get the output captured to the /home/anoop/capture_output.txt file. Instead, it simply connects me the Database.

tsql -H abcd.com -D DBName -p 1433 -U anoop -P somepassword select @@version go exit /home/anoop/capture_output.txt

locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Setting DBName as default database in login packet
1>

Would you be able to help me with this please?

I'm afraid, gszabo will not respond, his last activity was at 10th Jun 2016 13:26.
Probably would be better to open a new thread...

1 members found this post helpful.

Hello pan64,

Many Thanks for the suggestion. I've opened a new thread now.

I see that you've proposed to use "expect". I did explore on that without much luck. Would you be able to provide me a sample syntax for that?