How to write unit test cases for SSIS packages?

• Shriram Chandrasekaran

  Old Hand

  Points: 383

  More actions

  January 18, 2012 at 11:46 pm

  #266902

  Hi folks,

  i have a LLD to develop the ssis package. i need to write test cases for the ssis packages what i am going to develop. can any one tell me how to write test cases for ssis package and kindly share the templates if you have anything...

  Thanks & Regards,
  Shriram.

• Mahesh Lakkala

  SSC Veteran

  Points: 222

  More actions

  January 20, 2012 at 3:09 am

  #1436338

  You need to write test case for each task that is defined in the package.

  Based on the input, the expected result at each task should be validated as part of unit testing.

  Hope that helps !!

• JasonYousef

  SSCommitted

  Points: 1769

  More actions

  January 20, 2012 at 12:16 pm

  #1436677

  Hi,

  There's a community free project for that...http://ssisunit.codeplex.com/