Unable to run a simple SSIS (dtsx) package

[premkumarjayarampkj]

I am looking at tools to unit test BI tools and I found NBi a good fit for my requirements. So far, I am able to get SQL and SAAS working, however I also wanted to evaluate on ETL (SSIS) test execution.

I created a very basic SSIS package without any parameters, it just creates a table in a DB.

I tried to execute the simple dtsx package directly from drive as well as SSISDB using NUnit/Nbi, but no luck. I keep getting the standard error as System.ArgumentException : Value does not fall within the expected range.
I believe its failing before executing the ETL as I don't see any failures getting logged under SSIS reports.

NOTE: I am able to successfully execute those packages directly without NBi...fyi

Here is how I did

On SSIS DB

<test name="ETL">
   <system-under-test>
      <execution>
         <etl
            server="."
            catalog="SSISDB"
            folder="TestUT"
            project="Test"
            name="sample-2016.dtsx"
         />
      </execution>
   </system-under-test>
   <assert>
      <successful/>
   </assert>
</test>

From Disk

<test name="ETL">
   <system-under-test>
      <execution>
         <etl
            path="d:\Sample\"
            name="sample-2016.dtsx"
         />
      </execution>
   </system-under-test>
   <assert>
      <successful/>
   </assert>
</test>

I tried above with and without the .dtsx extension.

Please let me know if you require anything, I am looking forward to get this ETL running using the NBi framework. Appreciate any help/pointers on getting this to working.

Thanks.

[Seddryck]

Hi,

Could you post following informations:

• version of NBi used and if you're using any extension (version will also help)
• The full error message (not only the first line).