Post reply

Import multiple Excel files which has different schema

  • May 31, 2012 at 2:48 am

    #258804

    Hi All,

    How can we loop through multiple excel files if they are having different schema.

    Thanks

    🙂

  • May 31, 2012 at 8:43 pm

    #1495624

    SQL* (5/31/2012)

    Hi All,

    How can we loop through multiple excel files if they are having different schema.

    Thanks

    The standard Data Flow Task supports only static data flow definition at design time. You will have to create separate data flow for each schema you want to process.

    There is also a third-party commercial solution provided by CozyRoc. We have implemented enhanced Data Flow Task Plus, which supports dynamic data flows at runtime. You can process all your schemas using one For Each Loop container and one Data Flow Task Plus.

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

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

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