Reusing Tasks in SSIS

Question

How can I reuse a task in SSIS without copying / pasting?

For example, I would like to use the tasks that I defined in the event handler for one executable file in another executable file, but not with all the executable files in the package. So far, I have not found a solution other than writing a complete custom component that seems redundant. Any suggestions?

Answer 1

Have you considered the use of events at the packet level and filtering only for fire, when necessary for your specific condition?
For instance. you can use the OnPostExecute event by simply placing a dummy task with a name that starts on a specific line, such as "RunMyTasks", and then check System :: SourceName to see if it starts with "RunMyTasks". If so, then a branch to complete your tasks (and otherwise a branch to handle the event, as usual).

, OnVariableValueChanged - ( ). RaiseChangedEvent = TRUE. / script, ; , . post .

Answer 2

, CozyRoc SSIS +. Script Task Plus, Script , .