cancel
Showing results for 
Search instead for 
Did you mean: 

Having issue with .contains

TAM
New Contributor

Here is what I have $message.contains(‘successful’) ? 1 : 0 . This should give me a count of “1” if the Stored Procedure executing correctly. I then have a UNION, AGGREGATE and a ROUTER to count the SQL EXEC snaps, however it is only counting the first one and not the rest. At the end I have an email if $cnt == 10 then Success email, if $cnt < 10 then Failure email. Since the counts are not happening the emails are not generating. Any help is appreciated.

14 REPLIES 14

TAM
New Contributor

image

aleung
Contributor III

You do want have Validate & Execute on any snap you want it to run during Validate
Screen Shot 2021-05-04 at 3.23.38 PM

TAM
New Contributor

Now you have all of my pipeline and how it is running, any thing here that looks wrong?

TAM
New Contributor

image

TAM
New Contributor

Last thing this is the UNION at the Beginning, it is set up like an SSIS package. Fist two are before the Union so they start first and then the other 9 go after.
image