Post reply

format file

  • January 20, 2005 at 11:44 am

    #102357

    Can anyone pl let me know how to create a fmt file from sql 2000. i tried teh bcp cmd and it gives error as cannot use OUTPUT option when passing a constant to a stored proc. any help will be greatly appreciated.

    TIA

  • January 20, 2005 at 12:03 pm

    #538372

    I also get the error as

     Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. when doinga  bulk insert. any help??

  • January 20, 2005 at 12:42 pm

    #538380

    Are there possibly extra control characters in the data that you are trying to BCP? (for example carriage returns and line feeds within a varchar or text field)


    Shamless self promotion - read my blog http://sirsql.net

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

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