I have a SP that does a bunch of selects and some updates, it ends with doing a select from several temp tables its built, and then doing the update. My questions is, when I run it manually for the first time i get all the records i would expect.
If i run it from SSIS for the first time i dont get the results i expect, its like the updates that are in the SP have already occurred and so it reduces the number of records I would expect to get back. My question related to the validation
peice, does it actually run the SP when it validates, if it does it would answer my question i guess since its doing the updates. If it doesnt, not sure hot to explain the diff
View Complete Post