Results 1 to 2 of 2

Thread: SQL DTS query to Excel

  1. #1
    Join Date
    Aug 2005
    Posts
    13

    SQL DTS query to Excel

    I'm building a DTS package to query some tables and export the result to my local c: drive in Excel format.

    I have a batch file that stamps the date and copies the file to another location (in the same package). It appears that the process is trying to stamp/copy the Excel file before the file is finished being written to. Is there any way to have the package wait for the completion of the file before the batch file starts? I have inserted a wait command (30 secs to 30 mins) within the batch file to no avail. I can run the package without the batch file and it completes within 10 seconds. Thanks.

  2. #2
    Join Date
    Aug 2005
    Posts
    13
    I went ahead and did another package for the batch file...problem solved. Thanks.

Posting Permissions

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