search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

Unable to run a simple SSIS (dtsx) package #659

Open premkumarjayarampkj opened 2 years ago

premkumarjayarampkj commented 2 years ago

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 commented 2 years ago

Hi,

Could you post following informations: