This is just a example bro! The original tableA has 42 fields and TableB has 34.

Create Table A (

ID Varchar(15),

ADDR VARCHAR(20),

STREETNOVARCHAR(25)

)

Create Table B(

ID Varchar(15),

LNameVarchar(20),

FNameVarchar(20),

ADDRVarchar(20),

L_IDVarchar(15)

)

-- Insert values in Table A

Insert into A...

its work now but result showing "Only 1 row effected"

but i m sure A.snumber and B.snumber are same except dashes.

Any advice?

Once again Thanks all of you guys.

I really appreciate your prompt reply.

Now i m getting this error "A.Snumber could not be bound" :crying:

Update Table B

set I_id = tableA.id

from tableB

inner join tableB

on tableA.snumber = tableB.snumber

and tableA.add = tableB.add

"Query Success 0 row infected"

Please guide me where i am wrong.One more thing

tableA.Snumber = 1...

First of all i really appreciate your reply. I am using SSIS to finish this project, and i am using EXCEL SOURCE file and OLE DB source. i want...

I am sorry i think its my mistake, Could you please tell me which part you didn't understand yet?

Below statement are my actual question.

"Source table field (NAMEONE, NAMETWO)...

I am really sorry about confusion. Let me try to explain one more time. I have source "Flat file" called

"Nameone" "Nametwo" and so on.

I wana map these two fields...

I am sorry i forget to add something. In the target table there are few fields has "Nameone" and "Nametwo" , some of them has only "Nameone" and some as...

Thanks for reply!.

There is two different fields in my source table

Nameone ...

Thanks. I used derived column transformation and then i used multicast. Thanks for your reply and ur time:-D:-D

I am really sorry i can't help you at this moment because i just start working SSIS Job. Please update us if you find solution, Its really help for us....

Bro Here is one problem:-

Source Table:-

Owner_Address || Owner_Street

Cont_Address || Cont_Street

Emp_Address || Emp_Street

Target Table:-

1) Address

2) Address_Type

Questions:-

1) I want to Mapping Owner_Address || Owner_Street , Cont_Address || Cont_Street and...

Thanks for your reply. My target table has field called "P_id" and its "Primary key" and requirement is 'P_id" always auto generate i.e "cba-000001", "cba-000002".

* In target table or...

You are the man! you solve my issue. Thanks.