Some random stuff around SQL Server
The post is a second part of the series. In the previous one, I created an SVG image of the simple SSIS package, but when I tried to draw something advanced (upper image below) I got something far from expected (lower image below). This time I’ll fix it.
Continue reading
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
Continue reading
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?
Continue reading
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.
Continue reading
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.
Continue reading
In the Q & A post after the webinar on ssisUnit (in 2013) John Welch answered the question about the loops: “If possible, can you demo if a container can be executed? Especially a For loop or For Each loop?” I didn’t have time to demo this during the presentation. Good thing too, because there was an error around handling of containers. This has now been fixed in the source code version of the project. There is no example though, so let’s add one.
Continue reading
When you set the packages’ references in the ssisUnit tests you have four options for the source (StoragePath) of the package: Filesystem – references the package in the filesystem – either within a project or standalone MSDB – package stored in the msdb database Package store – packages managed by Integration Services Service SsisCatalog – references the package in the Integration Services Catalog In this post, I will show you how to set the package reference (PackageRef) for each option.
Continue reading
One of the drawbacks of ssisUnit is that it has only its own test runner. You can run the tests either using GUI or the console application, but the output is not that easy to parse and to present on the report. I’m used to working with Pester output or using NUnit/MSTest frameworks that integrates nicely with other tools. In this post, I will show you how to prepare and execute ssisUnit tests using MSTest framework, how to automate this process, and how to run those tests with TFS (or VSTS).
Continue reading
In the previous post, I wrote about using datasets in the ssisUnit test. By default, the dataset query is executed against the data source each time the test is run. But we also have an option to store the dataset’s result in the test file. In this post, I will show you how you can use it.
Continue reading
One of the elements you can define in ssisUnit is a Dataset. In this post of the ssisUnit series, I will show you how to prepare and use it later in a test. The Dataset As you can see in the image above, the dataset is a named result that contains data. It has five attributes (although you can see just four of them in the GUI): Name (required) – the name of the dataset, used for referencing the dataset in a test IsResultsStored (required) – the boolean flag informing if we have the results cached (true) or we always ask the external source (false) Connection (required) – the connection
Continue reading