Importing CVS file into SQL Server

  • wishchicky

    SSC Enthusiast

    Points: 133

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

  • pietlinden

    SSC Guru

    Points: 62374

    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: 133

    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: 62374

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

  • wishchicky

    SSC Enthusiast

    Points: 133

    How do i get SSIS?

  • BrainDonor

    SSCoach

    Points: 19182

    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: 148246

    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

  • This was removed by the editor as SPAM

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

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