Import multiple Excel files which has different schema

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  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

  

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  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/