activex function

[LucasH]

Hi all, quick question. SQL2000

I created an activex to use when importing data from a postgres db and calculate numerous statistics. However, I am running the import process in steps since the source table is so big. IE, run the package on 2002, then on 2003, etc. I use the same activex script for all imports, but since I created different packages for each, whenever I have to edit the script, I have to do it 15 times. Is there a way I can use 1 central script that is called each package? Much easier to support.

Lucas

 

[JayKusch]

Yes ... you would have to leverage ActiveX scripting, Global Variables and Dynamic Property Task to pass the needed connections and parameters to your master and sub-packages.

Thanks

J. Kusch