Post reply

Multiple Flat File Destinations from one OLE DB Source

  • September 29, 2010 at 7:15 pm

    #239067

    Is there a way to create 2 flat file destinations for the same OLE DB Source? First destination would be a ragged right file with naming convention of name.txt with destination of location1. Second destination would be a ragged right file with naming convention of name_timestamp.txt with destination of location2. I thought I would be able to drag another green line from the OLE DB Source to the second destination but was not able to do so. Any ideas?

  • September 30, 2010 at 11:21 am

    #1229756

    You can only have one "green" output from a source. You can connect that output to a Multicast. The Multicast can have multiple outputs. You can use these outputs to connect to each of your destinations.


    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]

  • September 30, 2010 at 1:29 pm

    #1229875

    Thanks Alvin!!! Multicast does exactly what I want.

  • September 30, 2010 at 1:31 pm

    #1229877

    You're welcome


    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 4 posts - 1 through 3 (of 3 total)

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