Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
exxoid
Starting Member
5 Posts |
 Posted - 2008-10-06 : 22:49:07
|
| Hello,I am looking for ideas on how to accomplish a task of importing data from a csv file into SQL Database; basically we are taking data from our Progress server which is configured to export the data in a csv file for SQL Server to pick-up and feed to its database.What I want to be able to do is, get SQL Server to monitor a folder for any new csv files and once they are seen import them into the system. This would be ongoing and SQL Server would need to check every 5 minutes or so.However, the data could be UPDATE, DELETE, INSERT type of imports; can this be accomplished by SSIS?The CSV in simple speaking would look like this.ID;data;data;data;dataNow I want to be able to, based on the ID for SQL Server to know if the data coming in is UPDATE, DELETE, INSERT (if its already there, update it, if not, insert it).Has anyone got any idea on how to do this?Thank you for your time and effort. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 05:43:15
|
| seems like what you want is a file watcher taskhttp://www.sqlis.com/23.aspx |
 |
|
|
|
|
|
Continuous Data Importing from a CSV?