String or binary data would be truncated – Some random stuff around SQL Server

2020-09-24 bartekr

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?!

2020-09-01 bartekr

Have problems with Docker Desktop for Windows Home? Yeah, me too!

Last week finally came that day: “I will give a shot to a Docker Desktop for Windows 10 Home”. To make it possible I run a long-postponed Windows Update to version 2004 (it allows to use WSL2). The upgrade and installation went smoothly, but the docker refused to cooperate. Well, that was unexpected.

2020-05-19 bartekr

Adding a new task in TFS/Azure DevOps using Excel

In the previous post, I added the tasks to on-premises TFS using C#. This time I will add similar data using an Excel add-in. I will also learn how to accidentally remove the link from the task to the parent element.

2020-05-04 bartekr

Adding a new Task in TFS using C#

An assignment: using data from the Excel file (sample data below) insert them into TFS (on-premises). Automatically. Start. You have three months from now. Or a few hours.

2019-08-07 bartekr

Draw the SSIS Package using SVG – part III

In the third part of a series, I focus on drawing the constraints’ descriptions and the colours. And also a bit of PowerShell for automation.

2019-07-16 bartekr

Draw the SSIS Package using SVG – part II

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.

2019-07-08 bartekr

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

2018-11-05 bartekr

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?

2018-09-12 bartekr

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.

2018-08-13 bartekr

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.