Using the system OAuth token in Azure DevOps

One of the new YAML pipeline steps I prepared recently involved interaction with work items. I wanted to add the comments to the task (with the task ID extracted from some file). So, I created a PowerShell step that was executing Invoke-WebRequest (with try/catch logic, obviously), the process finished successfully, but nothing happened. I mean – the comments were not there. Uhmmmm, why?!

Share
Continue reading

Draw the SSIS package using SVG – part I

For one of my projects, I need to draw the content of an SSIS package. It should not be a big problem, as the file contains all the required information. If you need to do something similar – I write a series of posts on how to achieve it using SVG, XSLT transformations and a bit of PowerShell (and maybe something more along the way). All the code is available on GitHub. The setup I start with the sample package as on the picture. It has three elements aligned vertically, with AND precedence constraints, evaluated as Success. It also has a small annotation on the side. The part responsible for

Share
Continue reading

Working with properties in ssisUnit

One of the ssisUnit commands is a PropertyCommand. It allows you to read or set a property of the task, the package or the project. As of the time of writing – you can’t test the properties of the precedence constraints or data flow elements (but you can’t currently test data flow at all). How do you use it?

Share
Continue reading

What’s new in ssisUnit?

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.

Share
Continue reading

Writing ssisUnit test using API

In the post about using MSTest framework to execute ssisUnit tests, I used parts of the ssisUnit API model. If you want, you can write all your tests using this model, and this post will guide you through the first steps. I will show you how to write one of the previously prepared XML tests using C# and (again) MSTest.

Share
Continue reading