Script to inject CSV Files in SQL Server

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

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

Microsoft SQL Server SQL Powershell Software Architecture

Project ID: #21226160

About the project

20 proposals Remote project Active 4 years ago

20 freelancers are bidding on average €81 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
(78 Reviews)
7.7
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
(336 Reviews)
7.8
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
(952 Reviews)
7.5
jabldamian26

Hi. hope you are doing well. As an web expert, I am very glad to see your project. Please check my profile here. https://www.freelancer.com/u/jabldamian26?w=f I have experience in development of the similiar projects. More

€100 EUR in 7 days
(10 Reviews)
6.1
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
(77 Reviews)
6.0
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
(18 Reviews)
5.9
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
(69 Reviews)
5.9
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
(30 Reviews)
5.7
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
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
(35 Reviews)
4.9
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
(13 Reviews)
4.1
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
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
(15 Reviews)
3.9
aap31374

Dear Sir.  I  have more then 10 years of experience in SQL Server databse development and Administration. We can create package and schedule job which can injest data from csv to sql. I have worked with medium to l More

€55 EUR in 3 days
(5 Reviews)
3.4
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
(5 Reviews)
2.9