January 11, 2017 at 11:53 am
Good Afternoon Guys,
I am fairly new on creating SSIS and was able to create a very basic and simple SSIS package. I would like to ask how do you do unit testing for your SSIS packages? what tools in Visual Studio 2015 I need to download so I will be able to do my Unit Testing Properly. Any advise/recommendations from you guys is very much appreciated.
Best Regards,
Noel Isip
January 11, 2017 at 12:14 pm
Stylez (1/11/2017)
Good Afternoon Guys,I am fairly new on creating SSIS and was able to create a very basic and simple SSIS package. I would like to ask how do you do unit testing for your SSIS packages? what tools in Visual Studio 2015 I need to download so I will be able to do my Unit Testing Properly. Any advise/recommendations from you guys is very much appreciated.
Best Regards,
Noel Isip
One of the easiest ways I've found of doing this is
a) Learn how to execute SSIS packages from T-SQL
(If you have your packages deployed to SSISDB using the project deployment model, this is fairly straightforward)
and then
b) Create a database test project in VS.
Create unit tests in this project which include the execution of your SSIS packages.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply