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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply