Join Condition in DTS Package

[CrystalUser1]

Hi,

I created a DTS Package to migrate the data from one database to another database.

I need to migrate the data from source database which has two tables to destination database which has only one table.

source database tables

Employee table

ID
Name


Address Table

ID
Address

Destination DAtabase Table:

Employee

ID
Name
Address


I want to migrate the data from the two tables to one table. how to write the join query in the Execute Task or Transform Data Tasks?

where Employee.ID=Address.ID

please help.

thanks

 

[dbomrrsm]

specify the query:

select e.ID,e.Name,A.Address
from employee e,address a
where e.id = a.id

[blue]DBomrrsm[/blue]

 

[CrystalUser1]

many many thanks dbomrrsm.

 

[dbomrrsm]

a pleasure

[blue]DBomrrsm[/blue]