automatically upload csv data to sql server

I am looking for advice on how to approach a project. I have an application that periodically writes a csv file with data in it to a folder on a desktop computer. It creates a new csv file each time.

I need the data from each of these csv files to be written to a SQL Server database which is located on a cloud server.

The table in the SQL server database has columns that match the data in the csv file exactly, so mapping the data fields is straightforward.

I would like a utility that "montors" the folder that these csv files are written to. When a new csv file is put in the folder I would like the utility to automatically write this data to the SQL Server database.

Do utilities like this exista and are commercially available? If not can anyone recomend an approach to writting a solution to do this. I work in Visual Basic.net. I have worked with ADO.net so have some experience with reading/writing data to SQL server.

I am looking for an easy to implement solution and would appreciate any advice more experienced programmers could offer.

Thank you.
GIANTOCRAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tigin44Commented:
you can achive this by desinging an ssis package to load the csv file to the sql server and scheduling it to run every ie minute to check if any new csv file exists then run the ssis..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Aaron ShiloChief Database ArchitectCommented:
0
GIANTOCRAuthor Commented:
Thanks. I am not sure if this will work as the computer(s) that the csv files are being saved on do not have SQL Server installed.

I am looking for a solution that will run on a number of remote desktops and send the data to a SQL Server database located on a cloud server.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Aaron ShiloChief Database ArchitectCommented:
hi

the ssis solution can access the remote datasourses and read from them of copy the files to the server location.
0
Alpesh PatelAssistant ConsultantCommented:
It should be done by creating SSIS package on Cloud server if have access.

otherwise on out SQL Server and destination is Cloud database.
0
GIANTOCRAuthor Commented:
Thank you for the help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.