Post reply

how to Combine the 2 excel source output data

  • March 24, 2011 at 4:14 am

    #237348

    Hi Guys.,

    How to join he 2 differente excel source files data in single script component.

    Is it possible.,please share some example

    Thanks for advance

    Ranganathan Palanisamy

  • March 24, 2011 at 4:24 am

    #1302852

    Script Components have only a single input, so you can't do that. Have you had a look at the MERGE JOIN transformation?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • March 24, 2011 at 5:37 am

    #1302877

    Thanks for Reply.,

    i need one more suggestion as well

    My design

    Excel source1 Excel source2

    Merge join

    Script Component

    i am getting some error

    Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 2" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Please suggest wht should i do for this error

    Thanks

  • March 24, 2011 at 9:25 am

    #1303050

    Could you please send sample data set. It works fine with merge join.

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

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