ssisUnit

New Post: Getting Started

scottywakefield — Wed, 27 Aug 2008 09:30:21 GMT

for use with NUnit:

using System;
using NUnit.Framework;
using SsisUnit;

namespace MyProject.Tests
{
[TestFixture]
public class MyPackageTests
{
  [Test]
  public void ThisTest()
  {
   SsisTestSuite suite = new SsisTestSuite(@"..\..\TestConfigFiles\MyPackageConfig.xml");
   suite.Execute();
  }
}
}

New Post: Getting Started

johnwelch — Tue, 26 Aug 2008 17:45:19 GMT

I've updated the Getting Started page with a simple walkthrough, and the Product Sample page with a more complete sample package and test. Hope this helps. I'm going to continue adding documentation over the next few weeks.

Source code checked in, #22639

johnwelch — Tue, 26 Aug 2008 02:58:43 GMT

Updated Wiki: Product Sample Package and Test

johnwelch — Sun, 24 Aug 2008 03:00:14 GMT

This is a sample SSIS 2005 package and unit test. It will also work under 2008, once the package has been upgraded.

The attached sample works with v1.0 of ssisUnit. This hasn't been released yet, but it can be built from the current source code.

ProductSample.zip

Source code checked in, #22549

johnwelch — Sat, 23 Aug 2008 22:05:40 GMT

Fixing autosize problem with columns

Source code checked in, #22548

johnwelch — Sat, 23 Aug 2008 22:04:52 GMT

Resetting Test Run statistics each time it's executed.

Source code checked in, #22547

johnwelch — Sat, 23 Aug 2008 22:02:04 GMT

Adding error message for assert commands that don't return a value

Source code checked in, #22546

johnwelch — Sat, 23 Aug 2008 21:45:00 GMT

Adding shortcut keys

Source code checked in, #22543

johnwelch — Sat, 23 Aug 2008 21:30:19 GMT

Fixing defect with Event Handlers not being released

Source code checked in, #22541

johnwelch — Sat, 23 Aug 2008 20:40:41 GMT

Fixed DeleteItem bug where it tried to delete multiple items.

Source code checked in, #22536

johnwelch — Sat, 23 Aug 2008 20:29:49 GMT

Fixing TargetPath property issue

Source code checked in, #22535

johnwelch — Sat, 23 Aug 2008 20:22:37 GMT

Fixing Add Test GUI bug

Source code checked in, #22532

johnwelch — Sat, 23 Aug 2008 20:09:54 GMT

Fixed bug in PackageRef conversion

Created Issue: Change XSD to normalize the Setup and Teardown nodes

johnwelch — Sat, 23 Aug 2008 18:04:16 GMT

Setup and Teardown should be under the Tests node. Then, each set can be named Setup and Teardown, rather than TestSuiteSetup, etc. More understandable XML.

Created Issue: Allow the test to override the connection managers

johnwelch — Sat, 23 Aug 2008 17:45:15 GMT

The test should be able to set the connection of a connection manager. This is normally handled by configurations, but letting the test handle it could be useful in some scenarios.

Consider allowing a general /SET-like command, for setting any property of any task.

Commented Feature: UI Feature

johnwelch — Sat, 23 Aug 2008 16:45:42 GMT

Not sure about The UI you are planning for the future, but even having a tree view list to select a task from for a unit test would really speed development of tests. Something to the "Package Explorer" tab in BIDS.
Comments: ** Comment from web user: johnwelch **

This has been added in the TestRunnerUI

Updated Wiki: Getting Started

johnwelch — Wed, 20 Aug 2008 19:44:52 GMT

***Note: This example applies to the 1.0 version, which must be downloaded and compiled. The release version will be available soon.

The attached files contain a very simple package and unit test to illustrate the concept of ssisUnit. For a more complete sample, see Product Sample Package and Test.

Getting Started.zip

Updated Wiki: Getting Started

johnwelch — Wed, 20 Aug 2008 19:44:27 GMT

Updated Wiki: Getting Started

johnwelch — Wed, 20 Aug 2008 15:53:14 GMT

The attached files contain a very simple package and unit test to illustrate the concept of ssisUnit. For a more complete sample, see Product Sample Package and Test.

Updated Wiki: Getting Started

johnwelch — Wed, 20 Aug 2008 15:39:12 GMT

The attached files contain a very simple package and unit test to illustrate the concept of ssisUnit. For a more complete sample, see Product Sample Package and Test.