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?
 
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
 
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.