How to copy a specific table columns using SSIS?

Feb 21 2020 6:27 AM

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

Answers (2)