Do you test your SSIS packages? Probably not, and I think I know why – because it’s manual, boring, repeatable task. You prepare the package(s), set the parameters and variables, maybe prepare some data and run few times by hand in SSDT. It’s very hard to prepare the test – SSIS is very dependent on metadata, so paramterisation of the tables or databases is error prone and shifts the focus to not so important things instead of just the development. Probably you set some SQL scripts that verify data in the tables after package execution, but I think that somewhere inside you feel that it’s not enough.
On this session I will show you how you can start automating testing of the packages and the whole projects. I will show you few tools (free and paid) and real life examples how to start with unit and integration testing your SSIS packages/projects/solutions. I won’t say it’s nice and easy, but definitely it will pay off in your (next) project.