Completed

Script to inject CSV Files in SQL Server

Hi ,

I am Looking for a PowerShell script which can inject a CSV file into a Database on daily Basis.

following Details :-

1. find all the files based on "DateModified" filter in a specific Folder, copy them to "ActualDate" Folder .

2. connect to SQL Server and inject all the CSV files into Database.

3. generate a report of the inserted data.

Thanks

Skills: Microsoft SQL Server, SQL, Powershell, Software Architecture

See more: sql server bulk insert row limit, sql server batch insert, import flat file into sql server using stored procedure, bulk insert in sql server from csv file, sql server import csv into existing table, read csv file in sql stored procedure, import csv file into sql server management studio, import csv to existing sql table, xml files sql server vbnet, pdf files sql server database, compare csv files sql, files sql server cleanup, import wizard importing csv files sql server 2005, vbnet upload files sql server progress, php script upload csv files, saving pdf files sql server vbnet, convert dat files sql server, sql server 2005 insert data csv table dts, reading csv files sql 2000 dts, import csv files sql 2005

About the Employer:
( 5 reviews ) Hamburg, Germany

Project ID: #21226160

Awarded to:

artem127

Dear Client, I have read your requirement in detail. We can start work immediately, and I can give you perfect result. Thanks, Regards.

€100 EUR in 3 days
(2 Reviews)
3.6

27 freelancers are bidding on average €83 for this job

fattahaabdul

I can write scripts to inject CSV files. I have 8+ years of experience in SQL and php. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

€180 EUR in 7 days
(66 Reviews)
7.5
sumon355

Hello, I am not much familiar with powershell, so if you don't have any problem, i would like to use vb.net to import the CSV file to sql server database. Please let me know if you are interested. Thanks

€60 EUR in 2 days
(300 Reviews)
7.6
vano101

Hello I have extensive experience with Powershell including working with MSSQL Perhaps, there is one question - how should it determine table of DB to add data? Thanks

€55 EUR in 3 days
(865 Reviews)
7.4
dungforever

Dear Sir How are you? I am very glad to place a bid to your project and i can finish your project in 1 day I have read your description carefully and i am so interested in your project. I am skillful Shell script and More

€75 EUR in 1 day
(64 Reviews)
5.6
lkhelladi

Hello, I'd be glad to develop a python script taht injects csv data into SQL databse. Looking forward to having a chat with you soon ! Best regards.

€77 EUR in 1 day
(28 Reviews)
5.6
kipdev13

I have good experinces of PowerShell Script. I can complete this job within one day. Please discuss more about via chat. Thanks.

€75 EUR in 2 days
(72 Reviews)
5.9
kolosibalint

Hi there, I have created a number of VBA scripts that generate SQL insert and update statements to write data from a spreadsheet into an Azure (or any other SQL) database. I would build an Excel interface that allows More

€150 EUR in 2 days
(17 Reviews)
5.5
zu02

Hi, there I hope all's well with you. I can build MS Access app : Ms Access front end and SQL back end providing csv/sql server automation. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects More

€100 EUR in 2 days
(21 Reviews)
5.4
adeelpirzada

Hi, I would be eager to hear from you I am a Full Stack Lead Developer with a Decade of Experience with strong Expertise in Nodejs , ReactJs and Angular using Mysql or MongoDB. I have comprehensively developed More

€70 EUR in 7 days
(23 Reviews)
5.6
TSCreators

Hi Dear , I have 6+ years experience over asp.net(webform and mvc , core) for responsiveness work on bootstrap. you can see our sites and portfolio in our site below is the url: [login to view URL] h More

€100 EUR in 7 days
(21 Reviews)
5.3
AliSafder

Hi, My Name is Ali and I can work on it with immediate availability. Let's have quick discussion so I can work on it.

€75 EUR in 7 days
(29 Reviews)
4.7
goodwork20k

I am good in powershell, csv data handling along with automation and development, please let me know if you are good to award this project to me

€60 EUR in 1 day
(13 Reviews)
4.6
ganeshrasekar

Hi Its does not need Powershell script we can use c# script which can be schedule or SSIS job or Sql Job .. my bid price is 100

€100 EUR in 2 days
(15 Reviews)
4.2
kyleevert

Dear Client! I am very happy to see your project detail. I think it is just my project. :) As you can see in my profile, (my review: https://www.freelancer.com/u/kyleevert?w=f) I have much experience with your job. I t More

€75 EUR in 7 days
(2 Reviews)
4.3
unix515

Dear Sir. Glad to meet you. I'm very interested in your job post. Please Hire me. I'll do my best, will make you pleasure with my work. Thank you. Joe.

€150 EUR in 3 days
(8 Reviews)
4.0
amitbanerjee2812

Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Here is few recent work for website development : crm.n More

€75 EUR in 7 days
(4 Reviews)
3.4
harihut

Hello sir, I have 10+yrs of exp as a core sql server dba. I will quickly write a clean powershell script that do it's duty to import your excel files. I will make sure the script is working perfectly and provide you 1 More

€50 EUR in 1 day
(6 Reviews)
3.2
l0ginp

Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, M More

€80 EUR in 5 days
(2 Reviews)
2.7
Saimi786

I will give you a graphical user interface software which will be developed in c#. Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully More

€50 EUR in 7 days
(5 Reviews)
2.7
vladimir91216

Hi nice to meet you. I have very rich experience of mysql and powershell. I am senior fullstack developer with 7 +years of web developing. So your problem is n't messy that you think. It is very easy for me and it is n More

€80 EUR in 1 day
(1 Review)
2.4