locked
SSIS How to test SSIS packages for integration/unit testing RRS feed

  • Question

  • Hi Team,

    Could you please guide me to understand about SSIS Testing. Is there is provision to add new Unit Test project to do it.

    Thanks

    Wednesday, June 25, 2014 5:54 AM

Answers

  • See

    http://msdn.microsoft.com/en-us/magazine/dn342874.aspx

    There's also in codeplex

    http://ssisunit.codeplex.com/


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Wednesday, July 2, 2014 3:53 AM
    • Marked as answer by Mike Yin Monday, July 7, 2014 2:08 PM
    Wednesday, June 25, 2014 6:17 AM
  • hi,

    Use this link here is scenario as well;

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/26ea5f88-8028-45c3-ab72-c4d0d7bb2e1c/how-to-test-ssis-package-and-what-are-the-things-i-need-to-test-it-?forum=sqlintegrationservices.

    Thanks

    • Proposed as answer by Mike Yin Wednesday, July 2, 2014 3:53 AM
    • Marked as answer by Mike Yin Monday, July 7, 2014 2:08 PM
    Wednesday, June 25, 2014 6:26 AM

All replies

  • See

    http://msdn.microsoft.com/en-us/magazine/dn342874.aspx

    There's also in codeplex

    http://ssisunit.codeplex.com/


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Proposed as answer by Mike Yin Wednesday, July 2, 2014 3:53 AM
    • Marked as answer by Mike Yin Monday, July 7, 2014 2:08 PM
    Wednesday, June 25, 2014 6:17 AM
  • hi,

    Use this link here is scenario as well;

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/26ea5f88-8028-45c3-ab72-c4d0d7bb2e1c/how-to-test-ssis-package-and-what-are-the-things-i-need-to-test-it-?forum=sqlintegrationservices.

    Thanks

    • Proposed as answer by Mike Yin Wednesday, July 2, 2014 3:53 AM
    • Marked as answer by Mike Yin Monday, July 7, 2014 2:08 PM
    Wednesday, June 25, 2014 6:26 AM