Testing the loops in ssisUnit

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.

Share
Continue reading

Setting package references in ssisUnit

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.

Share
Continue reading