unexpected end-of-life encountered in data file

  • I have been trying to run a simple DTS package that would load/import a .txt file into a table. The txt file has {lf} for lines/rows and '," for columns. Each time I get an error message that reads "...unexpected end-of-life encountered in data file". Shall I provide some sort of EOF-line or indicate a number of rows to be loaded. Please advise. Thank you for your help

    igor


    igor

  • Dont have embedded CR LF ?? try a unixtodos on the file for double check.


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • This is almost always aformatting issue.

    Steve Jones

    steve@dkranch.net

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

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