'Copying LookupId into all rows in SSIS

I have two tables, one is LookUpTable where I have an id for AttendanceType = Remote. And I have another table where there is a column called AttendanceType.

I want to fetch the id from LookupTable and copy in all rows of another table into the column AttendanceType in SSIS package?

ssis


Solution 1:[1]

You can use a MERGE JOIN query depending on your RDBMS. You can also use the MERGE JOIN component and the SSIS OLE DB Destination. The data coming out of the sources must be sorted. To tell SSIS that the data is sorted, right-click on your source component. Click on show advanced editor then on input and output properties. Then pass the IsSorted box to True. Then, you must indicate to SSIS which column acts as SortKey, ie on which column to sort the data.

Solution 2:[2]

You can use merge join in ssis to join both the sources based on attendence type field and fetch required fields from both the tables.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Amira Bedhiafi
Solution 2 praveen kumar

Related Questions