Setting up schedule task

Results 1 to 2 of 2

Thread: Setting up schedule task

  1. #1
    Write to file Guest

    Default Setting up schedule task

    I need to have a schedule task write daily additions to text file. Each day a new file will overwrite the old file. I need help getting this done through schedule task manager in SQL 7. Does anyone know SQL command to write to text file? <BR>Is that possbile?<BR>How do I setup a SQL Command to export data to comma delimited file? <BR>I would like it to create separte files for each company that is in the company table?<BR><BR>Whats the best way to get this done.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Setting up schedule task

    Why not use VBScript, FileSystemObject and ADO via a WSH script?<BR><BR>just create a script with a .vbs extension and schedule it in Windows Task Scheduler<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts