0

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.

user2867778
  • 45
  • 2
  • 2
  • 9
  • You can implement an SSIS package as explained in [this](https://stackoverflow.com/questions/27315732/how-can-i-a-sql-server-agent-job-if-a-file-exists-in-a-server-folder) thread. – Michael Oct 13 '17 at 18:40

1 Answers1

0

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.

user2196728
  • 2,915
  • 3
  • 16
  • 15
  • Thank you!!! SSIS is what I'm currently using but how I can make that run automatically? – user2867778 Dec 04 '13 at 20:37
  • 1
    You can schedule jobs : http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/ – user2196728 Dec 04 '13 at 20:41
  • I am not sure you can pool automatically the directory and trigger SSIS when a new file comes in... – user2196728 Dec 04 '13 at 21:08
  • There are plenty of ways to import files.. question is how to automate the import process. Above link does not answer that question. – Mayank Aug 10 '17 at 15:12