BartekR profile pic

BartekR

SQL Server. SSIS. PowerShell. Azure.
1 wife. 1 kid. 5 dogs. 10 cats.

ssisUnit has a stable version for SSIS 2005 - 2014. It didn’t change much since August 2014, until August 2017. Then my Pull Request was merged, and it added some new functionality for ssisUnit.

First - it works with SSIS 2017. You can probably use it with SSIS 2016 packages, but I didn’t test it yet. Although - you can’t check everything - there are problems when you want to use Control Flow Templates in your packages. When I tried to read the variable from the container included from the template - it hangs for a few seconds and returns an incorrect result. It’s something to investigate later.

Project connection string setup

Second - you can get and set the properties of the project and its elements. Like - overwriting project connection managers (I designed it with this particular need on my mind). You can now set the connection string the different server (or database) - in the PropertyPath of the PropertyCommand use \Project\ConnectionManagers, write the name of the connection manager with the extension, and use one of the Properties. You can do it during the Test setup (or all tests setup), but not during the test suite setup, as ssisUnit is not aware of the project until it loads it into the memory.

Third - I added simple Dataset viewer/editor. It’s still a work in progress, but you can already use it to either visualise the data or to keep it within the test file (set IsResultsStored to true, open the DataSet and save the test suite file). You don’t have to prepare the XML representation of the dataset manually.

There are also some minor changes:

  • Fixed “No rows can be added to a DataGridView control that does not have columns. Columns must be added first” error in test results window
  • Dataset, PackageRef, ConnectionRef extend SsisUnitBaseObject - now you can see XML code in the GUI for these elements
  • Query Editor resizes with the window and returns unmodified code on cancel
  • added several library tests (a great way to get to know the ssisUnit model better!)

If you want to get the latest version - go to the GitHub repository, download or clone the source code, compile it, and run. That easy! In case you have some problems with compilation (or ssisUnit not working correctly) - open an issue or write a comment to this post.

Recent Posts

Categories

About

Posts about SQL Server, SSIS and automation for my future self, but you might find something useful.