July 11, 2018 at 12:55 pm
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?
July 11, 2018 at 1:31 pm
First order of business is to decide exactly what data conditions constitute a duplicate. Then write a query that identifies the existence or non-existence of those conditions by outputting only duplicates, so that the RowCount you generate from that SQL Task can be used to control the flow of the SSIS package, such that you proceed to the FTP step only when that RowCount value is 0. Without more detais about what is a duplicate and the structure of the table that needs to be queried, there's no way to help further.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply