I am new to DTS. How can I implement the following situation in DTS Package.
1. get data from EXCEL and define the key fileds in FILE A,
2. Check for existence of record in FILE A with the above defined key fields.
3. If the record exists in File A, Then Update.
I have 2 different Queries for Update & Insert for File A. But, don't know how & where to put condition to check record existence.
Can anyone help me??