Is the unit test in one SSIS package a way to flow data.
ex: sort testing - Verify that the sort is cleaned up.
There is a unit test setting for SSIS - see.
It's worth seeing but it can not solve your problem. It is possible to test individual components at the control flow level by using this framework, but it is not possible to separate individual data flow conversions - you can only test whole data flow components.
One approach can take that to redesign your package and split your dataphlu component into several dataphflo components that can be tested separately, though it will affect the performance of your package, Because you have to keep data anywhere between each data flow task.
You can use this approach to load the SSIS API one package and execute a different task by using the NUITT or similar framework.
Comments
Post a Comment