I have several DTS Packages that are scheduled to run every night. If I
change the Packages, which version will be run the following night? If its
the old one, how to I update the schedule to recognize the new version?

--
SQL2K SP3

TIA, ChrisR

If you do not specify the version # then it is always the latest

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ChrisR" <bla (AT) noemail (DOT) com> wrote

Thanks Allen. Im still a bit in the dark though?

Is the version cotained in this type of deal?

DTSRun /~Z0x9F8F7D0B93BlaBlaBla

Is it updated when a new version is added?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

yuck.

This will wrap version up for you and you cannoot change it unless you
regenerate the string (DTSRUNUI). Personally I prefer to use the DTSRUN and
the non-encrypted versions.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ChrisR" <bla (AT) noemail (DOT) com> wrote

Sorry to be such a pain Allan, but now Im really lost. Do you know if the
version gets updated when stored this way?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

No it does not.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ChrisR" <bla (AT) noemail (DOT) com> wrote