SSIS Script Component Testing Strategy
- by Paul Kohler
This question is in respect to the script component specifically. I am aware of ssisUnit etc…
With simple SSIS Scripts Components, it’s sufficient to let basic testing flesh out issues, however I am working with a script that has grown in complexity over time.
To better test the functionality I am considering abstracting the script logic into a DLL that gets deployed with the package, and then use the custom component in the script. The advantage is that the function will be more testable etc but it’s one more deployment artefact that needs to be managed.
My question is, does anyone know of a better way to test such an SSIS script in a more isolated manner than to run the whole package and examine the output?