Grant,

I think this article is a great primer for using VS to test stored procedures instead of other non-MS tools like SQL Unit etc. 

I would like to see this methodology be applied one step further - to use to test SSIS packages.  For me this is a very gray area in unit testing since (unless thing have changed) you can only test at the package level and not the individual "task" level and I havent seen hardly any "best practice" methodology. You can run individual tasks in the VS Business Studio project but I have not seen any caommands that would run an individual task from a command line, only the "whole" package. Can you provide me and community with any links that approach the subject of iunit testing SSIS packages and tasks in VS.  Good article!

Regards

James