Find Jobs
Hire Freelancers

PowerShell Script to query database and produce csv file

$30-250 USD

Finalizat
Data postării: aproape 3 ani în urmă

$30-250 USD

Plata la predare
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.
ID-ul proiectului: 30532357

Despre proiect

18 propuneri
Proiect la distanță
Activ: 3 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
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 în 1 zi
5,0 (45 recenzii)
5,1
5,1
18 freelanceri plasează o ofertă medie de $151 USD pentru proiect
Avatarul utilizatorului
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 în 1 zi
5,0 (368 recenzii)
7,9
7,9
Avatarul utilizatorului
Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards!
$250 USD în 7 zile
5,0 (25 recenzii)
5,3
5,3
Avatarul utilizatorului
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 în 2 zile
5,0 (21 recenzii)
5,1
5,1
Avatarul utilizatorului
I can help here. I have over 10 years of working with databases and ODBC connections. Let’s discuss further.
$140 USD în 7 zile
5,0 (7 recenzii)
4,2
4,2
Avatarul utilizatorului
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 în 1 zi
5,0 (7 recenzii)
3,8
3,8
Avatarul utilizatorului
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 în 2 zile
5,0 (1 recenzie)
3,4
3,4
Avatarul utilizatorului
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 în 2 zile
5,0 (7 recenzii)
3,1
3,1
Avatarul utilizatorului
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 în 1 zi
5,0 (2 recenzii)
2,0
2,0
Avatarul utilizatorului
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 în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 3 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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 în 7 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Darien, United States
5,0
21
Metoda de plată a fost confirmată
Membru din sept. 20, 2008

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.