SQL Server DTS Connection Parameters

[dontlift]

ARRRGGGHHHHH

Ok SQL Server Guru's this ones for you

I have a stack of DTS's, on one of our SQL boxes which need to be moved to 2 other boxes (different machine name & database names etc)

Does anyone know of a way to paramterise the connections within the DTS packages? the packages are run from command files so no problem with passing info in on command lines etc if needed

[Plotloss]

There should be, inside the DTS package, a vbScript file that declares the database name etc at the top of the DTS.

Replace these with arguments and that should be that.

[Mark.S]

SQL2000 introduced 'dynamic property' tasks which you can use to assign properties based on global variables. When you shift server you just change the global variables, problem solved.

Never saw anyway to deal with this in SQL7 though.