I need to create an export txt or csv to run daily and preferably email said file. The data seems doable at 2000-3000 records and a file size under 5mb.
I know how to pull the data into a qry but Im not exactly sure how to automate this to a daily email. I can create an SSRS report and set it up on a subscription but I cant seem to grab all the fields at once to pull into a report (thus making building the report very time consuming.
I would think there is an easier way to create an automated export through SQL