MS SQL Server DTS - Code Replication

Author

Code Replication

Jon Derbyshire

2006-03-24, 7:39 am

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

Shannon McLemore

2006-04-04, 1:29 pm

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:

> 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

Sponsored Links