I need to transform one single column values(columnA) from TABLE A in one database to another column B in TABLE B in some other database.
When i transfer columnA for example has (Employee names) but in the destination TABLE B it should be the (Employee ID). I have a lookup table which has the employeeID for the matching employee name.
I need only one single column gets updated in the destination TABLE B. without affecting any other columns.
I know this can be done in SSIS and i have created
* source oledb
But the problem is at the destination output TABLE B the lookup transform is inserting NULL values to the unmatched column.
Can someone please guide me which is the best way to do this ?
Similarly i need to include various flows for the destination table from various databases.