Home Forums Data Warehousing Integration Services flat file loads to stage 1 row short of expected RE: flat file loads to stage 1 row short of expected

  • May 4, 2015 at 1:56 pm

    #1795463

    I usually use this to open large flat files.

    http://www.portablefreeware.com/?id=693

    You should look at the errors to find your problem. Those will help you identify the row that's missing.

    Are you sure that you're missing a row?

    Could it be that you're counting an empty row at the end of the file?

    Are you using a data flow task? or something else?

    Could you use an error handler?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2