Dear all,
When I create a new version of a dts package I want the scheduler to
point at this version without right clicking and hitting the ‘schedule
package' drop down is there any way to just amended the scheduled job.
How do I put an identifier in for this new package?

Many thanks
Sam

The best way to do this is to use the Package Name in DTSRUN not the
encrypted Hex string. Using the name only will tell SQL Server to use the
latest version of the package.

i.e.

DTSRUN /E /SMyServer /NMyPackage



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"SG" <sgpgpjr (AT) yahoo (DOT) ie> wrote

Sam,

You can try this:

dtsrun /S<server_name> /E /N<dts_package_name>

This will ensure the latest version is always the one that executes.

Ermedin

sgpgpjr (AT) yahoo (DOT) ie (SG) wrote in message news:<fe3ac5dd.0404210251.1ef379f4 (AT) posting (DOT) google.com>...