CODEWITHSUNDEEP
ssis
Nitesh Kumar SHARMA
Nitesh Kumar SHARMA

Reputation: 98

comparing rows inside 2 text files ssis

I have 2 files as below. TextFile1.txt is the result after ssis package execution. But some rows are missing in this file. The original file which i should get is TextFile2.txt. So i want to compare these 2 files. I want to know the missing rows. File description is as below. "TextFile1.txt contains 20 columns and 31449 rows TextFile2.txt containts also 20 columns and 32447 rows."

Upvotes: 0

Views: 221

Answers (1)

Jayvee
Jayvee

Reputation: 10875

your conditional split should test for the null keys coming from the merge join and direct them to the output to show which rows are missing.

enter image description here

Upvotes: 1

Related Questions