hello folks!
I am new to SSIS tool..here i confused with table transformation.I have two database and two tables respectively.
Source:
Databas_A
--Table_A
Destination:
Databas_B
--Table_B
i have a query here : Query to use: select Id from Table_A where Id > 0
in --Table_B i i shud get only Id columns containing > 0 ids. and i need to add new columns for updatedId,created date.
How i should do using this ssis tasks? I searched over but only complete table copy is there