What i was trying to do is get the Modelcode (from storedprocedure) as we execute the storedprocedure to enter the value to Table A. Use this "Modelcode" to do look...

Is there any other way to get the tables ?

I have Firstname , firstname 1 , firstname 2 ,firstname3

If firstname is null thne firstname1 , if firstname1 is also null then Firstname2 ...will the case will work ?

Case when...

testing iFcode

I have written code , but it throws error.

SELECT textresponse

,[Last Name] as LastName

,[First Name] as Firstname

[City]

FROM

(

Select

textresponse AS textresponse

,questiONtext

From #T

)AS P

PIVOT(

Max(textresponse) FOR [questiontext] in ([Last Name],[First Name],[City])

)as...

So, Merge is good ? I am little confused to use lookup or merge.

Thank you. Merge join worked .

i am doing look up on destination to see if there is key already exists if not insert new record. SO i cannot send both match and unmatched to destination...

I did use lookup on column3 but this way we get only matched data right? i need all data + matched one too to insert into new table.

I would do it in tsql ...but wanted to do implment in ssis.

Because table a in one server and table b on other

🙂