Post reply

Regarding Excel File Using For Each Loop

  • February 16, 2011 at 3:00 pm

    #246879

    Hi I have two excel files in one folder Member 1 and member 2 the file names are different but the data inside is the same. Thats fine.

    I am trying to upload the data into a table in a database using for each loop. But i am unable to do it. I tried a couple of times but the same file Member 1 is repeating.

    Can you please tell me how exactly can i continue my task.

    Thanks.

    Maverick.

  • February 17, 2011 at 11:47 am

    #1288425

    maverick_immortal (2/16/2011)

    Hi I have two excel files in one folder Member 1 and member 2 the file names are different but the data inside is the same. Thats fine.

    I am trying to upload the data into a table in a database using for each loop. But i am unable to do it. I tried a couple of times but the same file Member 1 is repeating.

    Can you please tell me how exactly can i continue my task.

    Thanks.

    Maverick.

    You have to construct expression, which dynamically modifies the ConnectionString property of the Excel Connection Manager. The expression has to use the variable you use as your current iteration item in the For Each loop container.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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