Home Forums SQL Server 2005 SQL Server 2005 Integration Services 5 excel file each file contain 5 sheets we want to load into data using single Dtata Flow task RE: 5 excel file each file contain 5 sheets we want to load into data using single Dtata Flow task

  • July 17, 2013 at 1:47 am

    #1633114

    Let's start with number 1.

    Why a single DFT and a single source?

    You need at least 50 sources, and preferably not in one single data flow.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP