Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

RE: Expand / Collapse
Posted Thursday, February 1, 2007 10:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 20, 2016 11:56 AM
Points: 69, Visits: 81


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!





Post #341710
Posted Tuesday, May 29, 2007 5:42 AM



Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 17,172, Visits: 32,133
Hey, thanks for the reply to the article. Yes, I'd like to see a mechanism for unit testing SSIS as well. I think it'd probably be more useful than testing TSQL.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #369451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse