SQL Server Performance

Bulk Insert

Discussion in 'SQL Server 2008 General DBA Questions' started by Guestuser31, Aug 27, 2009.

  1. Guestuser31 New Member

    Hi GuysI need to do an insert from a txt file into a table in sql server 2005.However the table consists of 6 columns but my txt file has only 5 as I have to specify the other value in the stored procedure.How can I go about doing this?Is there a better way to import a txt file to table other then BULK insert?Thanks
    Guestuser31, Aug 27, 2009
    #2

  2. MohammedU New Member

    MohammedU, Aug 27, 2009
    #3

Share This Page