Hi,

I am trying to upload query data to a CSV file. I have created a DTS
package and its running fine when i run it manually. But, when i schedule it
is not updating the query contents.

I need your help to do this task:
1. i have one query to pull all details
2. another query to pull summary info
3. i have to write a csv file with the results of above two queries.
filename has to be in the given format.
4. This job has to run daily and upload file with latest data.

For the first time, it is uploading files correctly. But next time onwards,
it is uploading the same contents. I have used global variables to store the
query output value (RowSet) and used ActiveX Script to read the variable and
write to a file.

The problem is it is not refreshing the query contents.

Please suggest...

Thanks