Hello,I'm trying to stop an SSIS package through VB.NET code. I have a script task and in my condition if no records are found I dont want the package to continue.Thanks!

Depending on how you have the rest of your package configured, you have the following options (maybe more):1. Return failure using (C#) Dts.TaskResult = (int)ScriptResults.Failure;, or (VB.Net) Dts.TaskResult = CInt(ScriptResults.Failure)2. Throw an error with (C#) throw new Exception(), or (VB.Net) Throw (New Exception())Option 1 requires that the rest of your components be connected to the Script via a Success precedence constraint.

Thank you very much

Thanks for the C#-part!

An other way is to add an boolean variable "EndETL" and give it value True in your VB.NET code. In the next precedence constraint you can add the expression @[User::EndETL] == False and maybe even add a new precedence constraint for the @[User::EndETL] == True with a log and your end.