Sfrgttk

Father gets chickenpox, but doesn't infect his two children. How is this possible?

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

How bad is a Computer Science course that doesn't teach Design Patterns?

find command cannot find my files which do exist

Does a code with length 6, size 32 and distance 2 exist?

Ramanujan's radical and how we define an infinite nested radical

Badly designed reimbursement form. What does that say about the company?

Failing PhD, how to go forward?

Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?

'Dimension too large' error when setmathfont has the option Scale=MatchLowercase

Microphone on Mars

Is Apex Sometimes Case Sensitive?

"Cheaper by the dozen" phrase origin?

Is candidate anonymity at all practical?

Prove that a cyclic group with only one generator can have at most 2 elements

Is it ethical to apply for a job on someone's behalf?

how can I check if there's element in my arraylist that is not in the hashmap?

Run a command that requires sudo after a time has passed

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

Can "ee" appear in Latin?

How to know if I am a 'Real Developer'

Is Screenshot Time-tracking Common?

I hate taking lectures, can I still survive in academia?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

Fail SSIS “Execute Process Task” if false is returned

Simplest way to constrain an SSIS Execute Process TaskSSIS Design consideration with object variablesSQL Server 2012 Agent Job not providing full failure message for SSIS PackagesSSIS - insert system date variable as a execute sql task parameterSSIS Package Validation Error email task when attaching file created by previous taskHow can I eliminate false “connection string format is not valid” messages from SSIS log?SSIS Custom Task with a default Task UIAssiging stored procedure results to SSIS variableHow can I resolve SSIS Excel Connection Manager Error 0xC0209303?SSIS: Control Flow Task Skipped

0

I have an "Execute Process Task" that calls Powershell and checks if a folder is empty. I'm wanting the SSIS job to fail if $false is returned.

Here is the code

param ([string] $FolderLocation)



#$FolderLocation = 'C:TempIsFolderEmpty'



if( (Get-ChildItem $FolderLocation | Measure-Object).Count -eq 0)

{

    #Folder Empty

    return $true



} Else {



    return $false



} 

Any time I run this in SSIS, it always runs whether $true or $false is returned. I've tried creating a new variable and using it in the StandardOutputVariable but haven't had any luck.

ssis powershell ssis-2012

share

asked 4 mins ago

jdidsjdids

878

add a comment | 

0

I have an "Execute Process Task" that calls Powershell and checks if a folder is empty. I'm wanting the SSIS job to fail if $false is returned.

Here is the code

param ([string] $FolderLocation)



#$FolderLocation = 'C:TempIsFolderEmpty'



if( (Get-ChildItem $FolderLocation | Measure-Object).Count -eq 0)

{

    #Folder Empty

    return $true



} Else {



    return $false



} 

Any time I run this in SSIS, it always runs whether $true or $false is returned. I've tried creating a new variable and using it in the StandardOutputVariable but haven't had any luck.

ssis powershell ssis-2012

share

asked 4 mins ago

jdidsjdids

878

add a comment | 

I have an "Execute Process Task" that calls Powershell and checks if a folder is empty. I'm wanting the SSIS job to fail if $false is returned.

Here is the code

param ([string] $FolderLocation)



#$FolderLocation = 'C:TempIsFolderEmpty'



if( (Get-ChildItem $FolderLocation | Measure-Object).Count -eq 0)

{

    #Folder Empty

    return $true



} Else {



    return $false



} 

Any time I run this in SSIS, it always runs whether $true or $false is returned. I've tried creating a new variable and using it in the StandardOutputVariable but haven't had any luck.

ssis powershell ssis-2012

share

asked 4 mins ago

jdidsjdids

878

param ([string] $FolderLocation)



#$FolderLocation = 'C:TempIsFolderEmpty'



if( (Get-ChildItem $FolderLocation | Measure-Object).Count -eq 0)

{

    #Folder Empty

    return $true



} Else {



    return $false



} 

share

asked 4 mins ago

jdidsjdids

878

share

asked 4 mins ago

jdidsjdids

878

asked 4 mins ago

jdidsjdids

878

asked 4 mins ago

jdidsjdids

878