Post reply

Large flat file exception issue

  • July 31, 2014 at 1:36 pm

    #297219

    Hi All, I have a script task and I used Visual Basic 2010 code to change the delimiters inside a flat file (.txt) and write to another file.

    This is working perfect with a file has 2 million rows and 800 MB in size. But when I have a flat file has 19 million rows and which is of 4 GB file size is throwing the below error.

    Error: Exception has been thrown by the target of an invocation.

    Suggestions are greatly appreciated

    Thank you

  • August 6, 2014 at 9:09 am

    #1735680

    First try to get more error info, maybe turn on some logging to get the low level message.

    How are you processing the file? What does it mean that you are changing the delimiters how exactly are you doing this? If you could post some code regarding the opening and reading of the file that may help, also for a larger file you may need to read it in chunks.

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

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