Hi All
Can you please let me know how a VBSCript can connect to a SQL Server, run a pre-defined stored procedure (a simple select that returns a table results), then output the table into a file and save it at a location?
Many thanks!
User Profile
Collapse
-
VBScript for FTP log on and rename file?
Hi All
I wonder if any one can help me on this please... I would like to create a VBScript (or something similar) which when run,
1. It logs on to the ftp server, with a specified username/password.
2. In the current directory, it searches the file "abc.txt", if exists, it checks the timestamp of that file. If the timestamp of the file is between Monday - Friday, it renames the file to "abc.txt.zz z",... -
Batch (BAT) scripting to append to file without new line
Hi
I would like to create a batch file (bat) where it outputs some text (either by echo or calling some other script) and append to an existing text file. However, everytime a > (or >>) is used, it automatically adds a new line afterwards. How can this be avoided please?
For example,
echo a > text.txt
echo b > text.txt
echo c > text.txt
"....... calling some... -
Script to extract files information from ftp server
Hi
Wonder if you could help me with the following please.
I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The file names along with their creation date are then to be extracted on a csv file (or similar). Can this be easily... -
Script to extract details of ftp files
Hi
Wonder if you could help me with the following please.
I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The file names along with their creation date are then to be extracted on a csv file (or similar).
...
No activity results to display
Show More