142 How to use lookup transformation with cache file in ssis

[@JAE-gg1xb]

Hello Sir do you do Videos For SSRS too?

[@learnssis]

As of now I have not made any video on SSRS.

[@jayakumarjk123]

hii aquil when i use lookup transform in incremental load with 2 million records its taking more than 6 hours of time and i do have another table with 10 million records is there any faster way to perform incrimental load without using lookup

[@learnssis]

Try to use SQL Joins between the 2 tables and get the matched and unmatched records, it will be faster as compare to Lookup transformation in SSIS.