none
How to Combine 2 excel file source

    Question

  • Hi Guys.,

     How to combine 2 differente excel file output values ? is it possible?

    Please provide some example

    Thanks for advance

    Ranganathan Palanisamy


    Ranganathan.Palanisamy
    Thursday, March 24, 2011 10:06 AM

Answers

  • If there is some column on which you can join both the sources then yes you can do it using lookup (if using sql server 2008) or merge join.
    Nitesh Rai- Please mark the post as answered if it answers your question
    Thursday, March 24, 2011 10:23 AM

All replies

  • Can you give some sample data with expected result. That would ease up understanding the requirement.
    Nitesh Rai- Please mark the post as answered if it answers your question
    Thursday, March 24, 2011 10:10 AM
  • Thanks for reply .,

           Excel source 1 :   FName,LName,MName,Address,Phone Number ect

           Excel source 2 :  Salary, departmernt,employee ID ect

    we need to pass the script component. we do some string manipulation

     

    Thanks

     

                                   


    Ranganathan.Palanisamy
    Thursday, March 24, 2011 10:17 AM
  • If there is some column on which you can join both the sources then yes you can do it using lookup (if using sql server 2008) or merge join.
    Nitesh Rai- Please mark the post as answered if it answers your question
    Thursday, March 24, 2011 10:23 AM
  • Thanks for reply.,

                           i m using merge join control.,but while running time excel source file showing differente error

    Error Description:

    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.

    Thanks

     


    Ranganathan.Palanisamy
    Thursday, March 24, 2011 11:09 AM
  • Is the first excel connection manager working fine?


    Nitesh Rai- Please mark the post as answered if it answers your question
    Thursday, March 24, 2011 11:13 AM
  • ya it's not showing any error nitesh

    Design :

    Excel Source 1    Excel source 2

               Merge join

               Script Component

     

    Please share any design oriented problem.,

    Thanks


    Ranganathan.Palanisamy
    Thursday, March 24, 2011 11:27 AM