Find Jobs
Hire Freelancers

PowerShell Script to query database and produce csv file

$30-250 USD

Completed
Posted almost 3 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 30532357

About the project

18 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
$70 USD in 1 day
5.0 (45 reviews)
5.1
5.1
18 freelancers are bidding on average $151 USD for this job
User Avatar
Hello, As an expert in ms sql server, I am very much interested to provide you a solution to export the result of the query to CSV and save it to a specific location. Looking forward to have a positive response from you. Thanks
$75 USD in 1 day
5.0 (368 reviews)
7.9
7.9
User Avatar
Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards!
$250 USD in 7 days
5.0 (25 reviews)
5.3
5.3
User Avatar
Hello there, there’re 2 ways to do as you wish: 1. Make the stored procedure and use the ssis to produce csv files (prefered), 2. Use powershell to call the stored procedure to get the data and export to csv files. Pls share me your requirement so we can discuss. Waiting for your response if interested. Thank you!!!
$100 USD in 2 days
5.0 (21 reviews)
5.1
5.1
User Avatar
I can help here. I have over 10 years of working with databases and ODBC connections. Let’s discuss further.
$140 USD in 7 days
5.0 (7 reviews)
4.2
4.2
User Avatar
hi, i can program a powershell script for you in 1 day time. I know SQL SERVER I know the ODBC drivers I know the way to export to csv format I can trade right away. Please visit my portfolio to learn more about my services and experience at freelancer.com best regards
$250 USD in 1 day
5.0 (7 reviews)
3.8
3.8
User Avatar
Hi there. Hope you are doing well. I have read your requirement carefully and I am confident that I will finish your perfectly in time. SQL, Oracle, powershell, Linux, file operation are my main skills and I have experiences of 6 + years in web developments. I have one question. Did the csv file export module finish perfectlly?. Please contact me~ Artur
$200 USD in 2 days
5.0 (1 review)
3.4
3.4
User Avatar
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.
$140 USD in 2 days
5.0 (7 reviews)
3.1
3.1
User Avatar
As a way of introduction, I have 4.5 Years of IT industry experience along with Extensive experience in Automation in the IT Processes. I have an advanced level of PowerShell knowledge, and I can assist you with this script. I also have sound knowledge in SQL Server , T-SQL and RDBMS in general. As an experienced system admin I have created many Powershell scripts, functions , modules to automate various SQL queries. I will create the powershell script within short time , that will query the specified table with query and will generate the file in the format specified by you. Once you are happy with the script I will schedule the script in Windows task scheduler. Please ping me in chat , we will discuss further on the project.
$100 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Hello? I have read your description. I can provide the great result that you are asking for as I have rich experiences in here. Could you please open your chat box for me? Let's get a great result together. Thanks.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$80 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a professional oracle DBA with hands-on experience in MYSQL AND SQL Server 2012/2014/ 2016 extensive knowledge, oracle apps EBS R12.2 with RDBMS 12.1 and EXA - data X4 and X8 I am currently working in a bank in critical situations I have recently upgrade 12.1 to 19c I have also document I can share with you when we will start work on it I have very extensive knowledge please feel free to contact me Designed and implemented disaster recovery plan using standby databases with data-guard Created scripts for database backup, recovery, monitoring Performed data loads using Data Pump and export/import utility setting up a server machine with Linux OS and Oracle database installation and cloning of Oracle EBS and maintaining. Taking Backups and Cloning EBS 12,2.6 I'll support you other than this 24/7
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Darien, United States
5.0
21
Payment method verified
Member since Sep 20, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.