Post reply

Issue looping through multiple excel files with different sheet names

  • July 19, 2010 at 3:58 pm

    #148090

    I have an several similar excel files and all of them have just one sheet/tab under them with month names. Looping through multiple excel files and loading them into tables was working fine earlier using the For Each Loop Container until I started receiving files with different sheet names other than the default "Sheet1".

    Kindly suggest step by step instructions for implementing this. I have tried using the Script task but the package would fail while looping through the files.

    Thanks

  • October 22, 2011 at 8:26 am

    #1398328

    Have you had any response to your question offline? I am attempting to do the same thing. Thanks!

  • October 26, 2011 at 1:43 am

    #1399428

    Hi,

    I don't know what error you are getting. I just tried your scenario by putting 2 excel files in the source folder with data in Sheet1 and Sheet2 respectively. It is working perfectly fine for me.

    May be SSIS engine searches for the right sheet to use. I am using SSIS 2008 R2.

    Thanks,

    Swaroop

  • October 26, 2011 at 2:52 am

    #1399450

    Hi,

    Would you mind sharing your package so that one could have a look who is interested in the above topic?

    __________________________
    Allzu viel ist ungesund...

  • October 26, 2011 at 3:06 am

    #1399453

    I am not sure how to upload the package and the excel file to this thread. would you mind sharing your email ID!!

  • October 26, 2011 at 3:24 am

    #1399456

    swaroop.sahoo (10/26/2011)

    I am not sure how to upload the package and the excel file to this thread. would you mind sharing your email ID!!

    You can ZIP your files and attach it to your post. Thanks.

    __________________________
    Allzu viel ist ungesund...

  • October 26, 2011 at 3:31 am

    #1399460

    Here you go ..

  • October 26, 2011 at 3:47 am

    #1399469

    swaroop.sahoo (10/26/2011)

    Here you go ..

    Assuming the original poster meant to load the stuff into a SQL server table rather than into another excel file?

    __________________________
    Allzu viel ist ungesund...

  • October 26, 2011 at 4:07 am

    #1399476

    It is working with DB tables as well.

    Let's wait for the original poster to respond.....

Viewing 9 posts - 1 through 8 (of 8 total)

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