Post reply

Unit-Testing SSIS 2008 packages

  • April 1, 2011 at 3:38 pm

    #248210

    Hello, have anyone of you automated the unit-testing of SSIS 2008 packages?

    There's a Codeplex tool (ssisUnit) but it's buggy and very limited.

    In VS2010, you can automate tests for C# and SQL Server projects (T-SQL), but not for SSIS.

    Any ideas or feedback would be appreciated

    Jesus

  • December 10, 2014 at 1:29 am

    #1763699

    I am also willing to do the same, can someone help me out.

  • December 11, 2014 at 3:41 pm

    #1764241

    I'm not aware of anything like that existing.

    Sounds like you will have to create your own.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 12, 2014 at 8:11 am

    #1764437

    Pragmatic works have a SSIS unit testing feature built in to their Bi XPress product, but I have not tried it out so I can't tell you how good it is or how much you can automate.

  • June 17, 2015 at 1:58 am

    #1805957

    If you would like to write tests as you do it with C# you can try SSISTester: http://www.bytesoftwo.com/index.html.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply