User Profile

Collapse

Profile Sidebar

Collapse
aiko27
aiko27
Last Activity: Nov 11 '08, 11:03 PM
Joined: Sep 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • VBScript to run SQL Server stored procedure and output to file?

    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!
    See more | Go to post

  • aiko27
    started a topic VBScript for FTP log on and rename file?

    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",...
    See more | Go to post

  • 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...
    See more | Go to post

  • 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...
    See more | Go to post

  • aiko27
    started a topic Script to extract details of ftp files

    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).

    ...
    See more | Go to post
No activity results to display
Show More
Working...