'Import CSV into SQL Server 2008 R2 Automatically
How can I have SQL Server Import csv data from a folder automatically?
I have a folder named RawData on the root drive that a system is currently pushing a csv file to, so anytime there's a new file SQL Server should import it.
Solution 1:[1]
Maybe you can have a look here to get ideas about ways to import csv files into SQLServer : http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12
SSIS seems to be what you are looking for.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | user2196728 |