Catch Powershell Exception in SSIS Execute Process Task

Question

I used this guide to run the following powershell in a SSIS Execute SQL Task:

param (
    [string]$path = ""
)

cls

$data = gc $path

foreach ($line in $data){

    "Processing: $($line.Substring(0,10))"

    if ($line.Length -ne 512){
        throw "Ragged File"
    }
    else {
        continue
    }
}

Unfortunately, the task does not respect the throw. It will simply move past it and consider the task successful. Any help would be appreciated.

geldek · Accepted Answer · 2024-11-13 08:40:04Z

0

You can set the property of the PowerShell Task: FailTaskIfReturnCodeIsNotSuccess to "true". Optionally, FailPackageOnFailure property can be set to "true" (depending on your requirements).

answered Nov 13, 2024 at 8:40

geldek

5843 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Catch Powershell Exception in SSIS Execute Process Task

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related