Post reply

load multiple files into single destination

  • September 10, 2008 at 3:12 am

    #125388

    Hi gurus,

    How to load multiple flat file sources into a single flat file destination in ssis.is it possible tell be in detail

    thanks

    vasu

  • September 10, 2008 at 5:33 am

    #869533

    You can take multiple data flow streams and put them together using a UNION ALL component in your data flow. Then you will be able to direct them to a destination component.

  • September 10, 2008 at 2:01 pm

    #869960

    if you are more specific about your requirement then probably we can help you.

    The answer for your question is yes we can do it.

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

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

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