Importing CVS file into SQL Server

  • wishchicky

    SSC Enthusiast

    Points: 123

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

  • pietlinden

    SSC Guru

    Points: 62342

    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....

  • wishchicky

    SSC Enthusiast

    Points: 123

    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!

  • pietlinden

    SSC Guru

    Points: 62342

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

  • wishchicky

    SSC Enthusiast

    Points: 123

    How do i get SSIS?

  • BrainDonor

    SSCoach

    Points: 19148

    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.

    Steve Hall
    Linkedin
    Blog Site

  • John Mitchell-245523

    SSC Guru

    Points: 148218

    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