I have a SQL query that returns data properly in Data Management Studio. Target Server is SQL 2016. I need a way to run the same query and have it target a ODBC/server and produce the results in a CSV file with a specific naming convention plus the current date in the name. The query I wrote that works and only calls the columns I need with the altered naming conventions. In the end I need a PowerShell or script to run via Task Scheduler everyday on a desktop and save the data (csv) file to a specified location.
Hi, Requirement of script will connect the SQL Server with ODBC and query data and export to CSV. I am available to start right away and can complete the script within couple of hours. Thanks
18 freelancers are bidding on average $151 for this job
I have experience in PowerShell and SQL databases, I can help to generate this CSV data and to set it to run everyday via a scheduled task. Feel free to contact me and I can start working straight away.
I can complete the assigned job for 80$. I am very much confident in SQL server database. so i can handle the these kind of job very quickly and can convert these to. CSV format.