sgmunson (7/6/2015)
You could use an EXECUTE SQL Task with the destination of the data being a variable instead of some kind of recordset destination. Then you can test the variable before proceeding.
Yes I'm using an execute sql task. How would I do what you are talking about?