Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

RE: Expand / Collapse
Author
Message
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: Tuesday, July 15, 2014 10:28 AM
Points: 69, Visits: 67

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

 

 




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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 12:27 PM
Points: 15,541, Visits: 27,919
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

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

Add to briefcase

Permissions Expand / Collapse