Post reply

How to Loop Text Files

  • July 7, 2010 at 12:12 am

    #220851

    Hi,

    i'm having 10 txt files in a folder that to be accessed sequentially. while running the package if any of the file get corrupted the momemt package should not stop till it access the 10th file in a row .

    mostly i worked on OLEDB as a source. but i don have much experience in Text file as a source. so, anybody help me how to achieve this logic through SSIS with steps .

    Very Urgent

    Thanks in advance!

    Regards,

    Sabarinathan.c

  • July 7, 2010 at 6:35 am

    #1189571

    What excaltly you mean by the word 'corrupted'?

    Raunak J

  • July 7, 2010 at 7:01 am

    #1189583

    Raunak Jhawar (7/7/2010)

    What excaltly you mean by the word 'corrupted'?

    What exactly do you mean by the word 'excaltly'?

    :hehe: just kidding - couldn't resist it.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • July 7, 2010 at 8:28 am

    #1189651

    Hi ,

    Its not 'corrupt' ..

    usually while executing the package if any problem occur the package will fail. but in my case the package should not fail it should keep accessing the next Text file in a row till it access the last file .

    Regards,

    Sabarinathan.C

  • July 7, 2010 at 9:57 am

    #1189717

    There should be a max error count propert on the container, you can turn that up and it should continue.

    CEWII

Viewing 5 posts - 1 through 4 (of 4 total)

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