Hi ,
I have a SSIS pacakge , which runs the Storedprocedure and results to Csv file and then loads to FTP server. But Stored procedure has data coming from temp table. Right now , package and code runs fine , but client wanted to send email upon duplicates. So, my question is I wanted to add a EXECUTE SQL TASK ...where it runs the query to check the duplicates and send email , instead to uploading to FTP server , but the stored procedure pulls data from Temp table. How can i check the dupes in SP?