I currently have a package setup to run a transformation service. As part of the transformation service, I am running a validation rule to check that the file is valid by looking for a Null Value in the first record. If a Null Value is found, I have the process set to \"Abort Processing\".
I assumed that by doing that the package would stop processing, and then I would receive a \"Failed Notification\" e-mail that I have setup as part of the \"transformation Process\" of the package, but, instead it seems to flow through the rest of the package as normal.
How can I fail the package if the validation rule fails in the transformation.
