Successful etl


More information on how to define an etl in a system-under-test can be found there.

The process for testing that an etl run successfully (no failure during the execution, the result of the execution is a success) is really straightforward: you run your etl and check the state at the end of the execution. If the package returns a valid status then the test is successful else it fails. To achieve this, in addition of the etl defined in the system-under-test you will need to define an xml element named successful within the assertion.

A full sample would be:

<test name="Etl is successful" uid="0001">
  <system-under-test>
    <execution>
      <etl path="Etl\" name="Sample.dtsx">
        <parameter name="DestinationPath">C:\toto.txt</parameter>
      </etl>
    </execution>
  </system-under-test>
  <assert>
    <successful/>
  </assert>
</test>

To assert that a run is not successful just add a not attribute to the successful element.

<test name="Etl is successful" uid="0001">
  <system-under-test>
    ...
  </system-under-test>
  <assert>
    <successful not="true"/>
  </assert>
</test>