How to use unit test in SSIS

I build a SSIS Package in Visual Studio 2005 , but i don't know how to test it automated?

Steven,

I don't know of way of unit testing SSIS packags other than buildig a framework for it yourself. There is certainly nothing provided with the product to allow you to do this.

Do you think there should be?

-Jamie

|||

I have played around with using the data unit testing features in the Database Developer's version of Visual Studio to test SSIS packages. It was a bit of a hack, and the functionality was limited for testing non-relational destinations.

I, for one, would love to see better support for unit testing in SSIS. Here's a Connect request I just created for it:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=276292

|||

Nice one John. I'd definately like to see that.

I think it would be a lot easier to unit test SSIS packages if the package were not one stand-alone entity. If you could access different parts of the package outside the context of the package it would really help.

That is why I think this connect posting is such good ideas:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253500

-Jamie

|||Automated unit testing is difficult to do right now in SSIS.

It seems like when a given project has reached a size of 5+ packages (arbitrary number) , unit testing via point-and-click becomes untenable. "necessity is the mother of invention", and so I think various people will start forging their own test-automation "framework" on top of the framework provided in Visual studio Team Suite, Team Dev, or DB Pro, or perhaps nUnit. Its just too unproductive/time-consuming/error-prone to go through all the Integration Services project packages in a point-and-click fashion and make sure they all still "work" without some sort of automation system.
|||

I agree 100% percent. I'm a big fan of automated unit testing from back in my app dev days, and it's one of the biggest things I miss in working with BI tools. I think a decent tool could be built for testing control flow, but currently, I don't think SSIS provides all the "hooks" needed to really automate the unit testing of data flows, except as an end to end process. That makes unit testing data flows very similar to unit testing a method with 5000 lines of code in it .

I'm hoping Katmai will help.