August 10, 2010 at 9:14 am
I'm looking for some high level design help.
I loaded data into a table. I need to sum up the data and compare it with what it's 'supposed' to be.
The query (as it currently exists) returns rows where the data doesn't sum up correctly.
Therefore if there is no data returned from that query, I need to continue processing.
If there IS data returned from the query then I need to put that data out to a text file, report an error and stop processing.
I would like some suggestions on how you guys would write this in SSIS.
Bob McC
August 11, 2010 at 4:07 am
Rowcount operator on the query identifying whether there is erronious data, with two flows with Expression and constraint based upon the process completing sucessfully and the value of the variable containing the result from the rowcount operator being > 0 pointing to a sendmail task warning of the problem, the other with the variable value being zero pointing to the rest of the processing chain?
August 11, 2010 at 9:16 am
Thanks for the reply, Andrew. I have something very similar to that in place. Once I realized I was trying to do too much in one step; I decided to break it down into smaller chunks. I used an Execute SQL Task with and "IF EXISTS (xxxx)" command in it. This sets a variable to true or false, 0 or 1 (or whatever). Then by using precendence constraints, I interrogate that variable to take the appropriate path. At that point it's easy enough to get the invalid data and send an email; or finish processing down the other path.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply