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
@learnssis2 жыл бұрын
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.