Sujeet Raman

Sujeet Raman

  • 864
  • 927
  • 354.2k

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)