shell script to run sql analyser

• atl_dave

  Grasshopper

  Points: 12

  More actions

  April 24, 2003 at 1:32 pm

  #175593

  Here is my requirement..

  I have Sqlserver 2000 running on NT it is a remote system.

  I want to access this machine via telnet from a HP UX box and run a script.. The script will be for running a query and capture the data in a text or csv format and ftp to a remote machine,,

  I am trying to find out how i to pass the parms to get connected and get the spool file http://ftp..

  any takes on this

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 24, 2003 at 1:40 pm

  #455307

  You can use osql with the -i[path to the script] parameter to run a script with telnet.

  checl in BOL for all the parameters used by osql.