Union all

  • Hi

    I am supposed to combine the data coming from two different sources in DTS, is there any task similar to the UNION ALL of SSIS in DTS?

    Thanks

    Su

  • If I understand you correctly, the answer is no.

    I believe all you need to do is load the data from the first source into it's destination, then load the data from the second source into the same destination.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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