Hi,

I have 10 different DTS's, all of which have the exact same ActiveX script
task at the start.

I'd like to know if there's a way of storing my vbscript in 1 location,
rather than 10 locations, allowing for easier modification of my code?

Thanks in advance

Regards

Jon Derbyshire

Hi John,

I have this same need. Have you found a solution?

Thanks,
Seth

Jon Derbyshire wrote:

You could put the Active Script Task in a seperate package and save it as a
Structured Storage File and then add an Execute Package Task to every package
and reference the package saved as a Structured Storage File.
--
Shannon McLemore
http://sqldevelop.blogspot.com


"Jon Derbyshire" wrote: