Executing a Local Process from SSIS

Wraps an SSIS 'ExecuteProcess' task that launches 'SampleApp.exe' from a fixed path with a 300-second timeout and a hidden window. The task declares a task-scoped 'ProcessOutput' string variable and binds it to 'StandardOutputVariableName', so the executable's stdout is captured into that variable for use later in the control flow. A property expression on 'Arguments' formats the current date as 'DD-MM-YYYY' and passes it to the executable on every run.

Replace the 'Executable' path with your own executable, adjust the timeout, and edit the 'Arguments' expression to produce the command-line input your tool needs.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Packages>
    <Package Name="Execute Process" ConstraintMode="Parallel">
      <Tasks>
        <ExecuteProcess
          Name="Execute SampleApp"
          Executable="C:\users\bimlUser\Documents\SampleApp.exe"
          StandardOutputVariableName="Execute SampleApp.User.ProcessOutput"
          Timeout="300"
          WindowStyle="Hidden"
          >
          <Variables>
            <Variable Name="ProcessOutput" DataType="String" />
          </Variables>
          <Expressions>
            <Expression PropertyName="Arguments">
              RIGHT("0" + (DT_WSTR,2)DAY(GETDATE()), 2) + "-" + 
              RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()),2) + "-" + 
              (DT_WSTR,4)YEAR(GETDATE())
            </Expression>
          </Expressions>
        </ExecuteProcess>
      </Tasks>
    </Package>
  </Packages>
</Biml>