Reusable component in SSIS package
-
Greetings,
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?
Cheers
Paul
-
One possibility is to create a package with the common logic and call it as needed.
-
Is it possible to create a script task that is detached from everything else and call it from anywhere I want?
-
I have only done it as a child package. You might also take a look at creating event handlers. Perhaps some of what you want to do could be handled that way.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply