FileSystemObject
you can use the file system object direct from sql.
That way you can create a stored procedure that writes the results to a file.
Then schedule a task that calls the sproc.
That is probably the most robust and elegant way, hey, but if it's working who's complaining.
|