Post reply

Bulk Insert

  • November 3, 2008 at 8:15 pm

    #126582

    hi guys,

    i want to read and insert a csv file into SQL server. but i want to insert a specified columns in csv file. can anyone help me pls.

  • November 4, 2008 at 7:16 am

    #893604

    You can do this sort of thing using SSIS. Or you could use BULK INSERT or OPENROWSET to import the data into a staging table, from which you can then select the required columns.

    Karl
    source control for SQL Server

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

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