filmov
tv
SSIS Package||How to do Incremental Load by using ID in LookUp Transformation?
![preview_player](https://i.ytimg.com/vi/i8zJ43d-o8s/hqdefault.jpg)
Показать описание
Steps to do Incremental Load using LookUp:
1. OLEDB Source and select your source table
2. LookUp and Write SQL Command with ID (Lookup column) from Target table and select Ignore Failure
3. Conditional Split - Write condition on ISNULL(ID) for INSERT and Default Output as UPDATE
4. OLEDB Destination for INSERTS and select your Target table
5. OLEDB Command for UPDATES and write your UPDATE Statement in your target table with all Question Marks.
6. Within the Column Mappings tab, we must assign the appropriate column name to the parameters.
First Question mark will be Parameter 0, Second Question mark will be Parameter 1, and so forth.
1. OLEDB Source and select your source table
2. LookUp and Write SQL Command with ID (Lookup column) from Target table and select Ignore Failure
3. Conditional Split - Write condition on ISNULL(ID) for INSERT and Default Output as UPDATE
4. OLEDB Destination for INSERTS and select your Target table
5. OLEDB Command for UPDATES and write your UPDATE Statement in your target table with all Question Marks.
6. Within the Column Mappings tab, we must assign the appropriate column name to the parameters.
First Question mark will be Parameter 0, Second Question mark will be Parameter 1, and so forth.