Post reply

bcp alternative for SQL Server 2005

  • October 20, 2006 at 9:11 am

    #174718

    Hello all, can anyone suggest a good alternative to bcp to use in stored procedures in a SQL 2005 environment? Just need to import some data from text files into a table.

    Thanks in advance...

    MEslinger

  • October 20, 2006 at 10:43 am

    #667141

    You could do BULK INSERT or OPENROWSET utilities. Any particular issue with BCP for not using it?

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • October 20, 2006 at 11:36 am

    #667164

    I was told it wont work in SQL 2005, and Im getting an error when I try to compile my script that says 'unable to open BCP host data-file.'

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

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