Post reply

Text File Import Errors: Missing Rows

  • December 18, 2001 at 4:24 am

    #157536

    Another department have written a DTS package which uses Text File Import rather than direct DB connection (which I am used to). There is 37 rows in this text file, but the load only seems to pick up 32. The developer assures me that the file doesn't contain any 'weird' characters, so now I'm a bit stuck. Any ideas what might be the problem? This is on SQL 2000 SP1.

    Thanks

    Dave Francis

  • December 18, 2001 at 5:09 am

    #421205

    Maybe they have it skipping a 5 row header? I'd set the error logging on the package, see what happens. If you have VB available, save the package as VB, then step through the code in the IDE, that will give you a chance to see for sure.

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • December 21, 2001 at 10:28 am

    #421378

    Ok, I'll have a go. Thanks

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

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