Results 1 to 2 of 2


  1. #1
    Join Date
    Dec 1969

    Default BULKINSERT

    Hi.<BR>I have a number og text files that I am bulkInserting into the db. THese files are generated by an external system which I have no control over. These text files have an inconsistant number (7-8) of Carriage returns appended at the end of the data.<BR><BR>When I run the Transact BulkInsert statement, I get the ff error;"[Microsoft][ODBC SQL Server Driver][SQL Server]Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.<BR>". If I delete these Carriage returns , the statement succeeds.<BR><BR>How can I programmatically remove these Carriage returns ? However I don&#039;t want to use 1. DTS, 2. To read the text files line by line and test for each line if it is blank, until AtEndOfStream is true. This method is too slow (Time is critical for me here)<BR><BR>I&#039;d appreciate help in this matter.

  2. #2
    Join Date
    Dec 1969

    Default RE: BULKINSERT

    The options are limited to the ones you don&#039;t want to do or tell who ever is responsible for the data to clean it up!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts