Our Training Programs

All contents are copyright of their authors.

How to copy a specific table columns using SSIS?

How to copy a specific table columns using SSIS?

Sujeet Raman

6yAsked Feb 21, 2020, 6:27 AM779Learn iOS Programming

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Sujeet Raman6y ago
I am able to copy some values.but in Id i am getting error --

Cannot convert between a unicode and a non-unicode string data types..in OLEDB Destination

i have changed the datatype in i/p datatypes in source properties to Unicode string [DT_WSTR] but still the same error
Jignesh Kumar6y ago
Hi Karthik,

Please find below link which will help you,
https://www.tutorialgateway.org/copy-column-transformation-in-ssis/