I have some work (e.g. logging information to a file, logging information to a database) that I need to do in several places in my SSIS package. I also need to be able to do this work inside script tasks.
Obviously I do not want to repeat this unit of work. Any suggestions on how I can create a reusable "component" in the package that I can call from anywhere I want?
Of course I could create an external assembly and reference and call it whenever I want from the script tasks, but is there any other way to keep the reusable component "inside" the package? Is there a "script component" task or something I haven't seen yet? :-)