July 31, 2008 at 9:18 am
I know in DTS you can create a global ActiveX script, but is there something similar you can do in SSIS? I have a function that will be called from multiple script tasks, so instead of copying and pasting it in each task, I wanted to create a global function and have all of the tasks call it.
Thanks,
Michael
July 31, 2008 at 9:38 am
I don't think that there is a way to do this in SSIS. In SSIS you would compile the function in a DLL and then reference the DLL. You need to sign the DLL and put it in GAC and in on any machine you will be running the package from.
Look in BOL SSIS for "custom objects [Integration Services]" for how to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply