(imported topic written by NathanW.)
Is it possible to create a scheduled activity (custom or otherwise) that exports a web report as CSV to a defined network directory? So far all I can find as distribution options would be archive, which I assume resides on the local web reporting server, e-mailing the file as an attachment, or e-mailing the file as a link.
I would like to automate this process so that some of our SQL Server processes can pick up the CSV files from the defined network directory and import them into a centralized database for further analysis/tracking.
Thanks!