• First of all, wrong forum. This is the forum for DTS, which is the predecessor of SSIS and it's a totally different product.

    Secondly, why only one DFT? You can add as many on the control flow as you like. Furthermore, you can also put multiple sources and destinations in one data flow. However, this can impact performance: Too Many Sources in a Data Flow[/url]

    For question 2 and 3, you need to give a little bit more detail.

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