Sedang Disiapkan

VBScript/Powershell to Update .csv based on SQL Query

Simple VBScript or Powershell project to Read .csv file with Header, update "EmployeeID" fields in .csv based on a sql query to determine:

If the Employee ID exists in SQL Database, then replace .csv with EmployeeID from SQL.

If the Employee ID does not exists in SQL Database, replace .csv with Max(EmployeeID)+1 from SQL

Update entire .csv file on these rules.

Kemahiran: Skrip Kekerang

Lihat lebih lanjut: powershell update csv, powershell query update csv, powershell csv sql, powershell sql exists update, powershell, update csv file powershell, vbscript update csv sql, powershell update employeeid, on sql, vbscript, sql query, sql based, simple csv, update sql file, shell script csv, csv update, sql file csv, sql employee database, employee database sql, database query project, employee database, project based sql, project sql query, simple project sql, project query

Tentang Majikan:
( 1 ulasan ) Tampa, United States

ID Projek: #1573621

Dianugerahkan kepada:

subramaniankv

I am familiar with VBscript. I can get this done in two mandays.

$80 USD dalam 2 hari
(2 Ulasan)
2.1

5 pekerja bebas membida secara purata $150 untuk pekerjaan ini

pilica

I have experience in scripting. I can do this job.

$120 USD dalam 4 hari
(1 Ulasan)
1.7
jaydev12

Hi, I can give you best solution on this

$300 USD dalam 15 hari
(0 Ulasan)
0.0
forrestwang

hi sir, I can do your work with powershell.

$200 USD dalam 5 hari
(0 Ulasan)
0.0
marasinghe82

Dear Sir, I Can do this task using SSIS lookup task boss. Please assign this task for me I can assure 100% completion within 1 hours time. I'm very much familiar with MS SharePoint, MS SQL Server ( SSIS SSAS Lagi

$50 USD dalam sehari
(0 Ulasan)
0.0