Post reply

for each loop problem

  • May 21, 2010 at 1:08 am

    #139091

    i have a folder which contains a csv files with four column , five column six column files

    i am using for each loop through the files and using conditional split

    i am checking no of columns ( i.e FINDSTRING(Line,",",6) == 0)

    process the logic based on no of files

    the problem : its working for a file that is first parsed if it contain five columns its working if the second file consistes 4 column its continues to use 5 columns logic path even though it has four column.

    its working fine if the first file consists of mix of four and five column its woking as expected.

    can any body tell me what's went wrong?

    thanks in advance.

    pha

  • May 21, 2010 at 8:13 am

    #1170856

    I would suggest you to use a FEL with a script task that would check the number of columns and then move it to a DFT with the Help of a precedence Constraint.. So basically you will have 3 DFT's one for each CSV(four,five, six columns etc).

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

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