Post reply

5 excel file each file contain 5 sheets we want to load into data using single Dtata Flow task

  • July 17, 2013 at 1:37 am

    #276113

    Hi All,

    My Name is vivek,i have few doubts below any one know to how to resolve please give me advise.

    1).I have 5 excel files each file contain 10 sheets and how to load table by using sing DFT,in DFT we need to use single excel source and single destination.Is it possible in SSIS.

    2)each file contain country name, i need to load country names from file path's and product names from each sheet name.

    3)how to create dynamic files by using variable.

    Thanks,

    Vivek.

  • 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

  • July 17, 2013 at 2:00 am

    #1633117

    There is an example here that might be relevant to you.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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