Importing CVS file into SQL Server

  • Is there a really easy way to import data into SQL?

  • How long is a piece of string?
    Is this a one-off or do you need to import different files with the same structure?
    If it's a one-off you can use BCP. If you need to repeat it, you can use SSIS and create a job that runs on a schedule....

  • There are 9 items in the table. I can export from the website and import into SQL as a .cvs or html file. There is also a section on the website for MySQL mapping. There will be a different file each day with similar or varied data. I love the idea of creating a job that runs on a schedule!

  • SSIS package to get the file (download), then import the text file. Then schedule it using a job?

  • How do i get SSIS?

  • wishchicky - Tuesday, June 13, 2017 8:32 PM

    How do i get SSIS?

    If you're asking that question then SSIS would not be a quick solution. 
    Would the Import Data Wizard be more suitable? In SSMS, right-click on the database name, then 'Tasks/Import Data...'.
    Have a look at that and see if it would be good enough for your needs.

  • If it's a simple data load then SSIS is probably overkill anyway.  The Import/Export Wizard is good for one-off loads (and you can save it as well, but then we're back to SSIS).  BULK INSERT and bcp should also work well, and you can easily schedule them.

    John

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply