Terminé

PowerShell Script to query database and produce csv file

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.

Compétences : Powershell, Serveur SQL Microsoft, SQL, Script Shell, Architecture Logicielle

En voir plus : script import csv file database, database query csv file, script csv file sqlexpress database, csv file specification inventory data, script query database size, php script uploading csv file mysql database, script mysql query csv file email, script run mysql query write results csv file, update database php script csv file, linux script query database, php script insert csv file mysql database, powershell script create ad users excel file, php script mysql database import sql file, powershell script query printers desktop, csv file opens with data in a single column, reading csv file and displaying data in a datagrid, sample csv file with employee data, csv file not showing data, vba open csv file and copy data

Concernant l'employeur :
( 21 commentaires ) Darien, United States

Nº du projet : #30532357

Décerné à:

mrbrave

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(45 Commentaires)
5.1

18 freelances font une offre moyenne de 151 $ pour ce travail

sumon355

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 y Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(368 Commentaires)
7.9
Friends4it

We already have built large scale applications, CRMs, ERPs and huge systems can be found at our website. Like [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https: Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(23 Commentaires)
6.9
AhmadSameer

Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)
5.3
(5 Commentaires)
5.1
Truonggiang86

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(21 Commentaires)
5.1
(19 Commentaires)
4.6
croll12

I can help here. I have over 10 years of working with databases and ODBC connections. Let’s discuss further.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
4.2
greatswork

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 se Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.8
saadtariq329

Hello, I just had a sight on this attractive project and I’m more than happy to say that is lies in my domain. I’m professional & expert developer for years. I have quest in my mind for you about this project. I need a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
3.9
ArturAgababian

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 expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
3.4
mwmatthew10

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)
3.1
(6 Commentaires)
3.1
suryendubbhattac

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 s Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
2.0
(1 Évaluation)
1.7
nenadudovicic111

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
sajimohan

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
HassanMoin21

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 cr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0