SQL 2K job and DTS

I have a sql server 2000 job that is just doing an execution of a DTS pkg.
When you look at the syntax in the step of the job I see something like:

DTSRun /~ZO4858C301ABE2

The problem is, my DTS packages are not named in any uniform way with the
Job name, so I don't know which DTS package this job is running. My job is
failing, but how can I determine which DTS package it is executing?

I looked at the GUID, and that does not seem to be it.

On 21 Aug., 20:45, DTS Newbie
wrote:
> I have a sql server 2000 job that is just doing an execution of a DTS pkg.. *
> When you look at the syntax in the step of the job I see something like:
>
> DTSRun /~ZO4858C301ABE2
>
> The problem is, my DTS packages are not named in any uniform way with the
> Job name, so I don't know which DTS package this job is running. *My job is
> failing, but how can I determine which DTS package it is executing? *
>
> I looked at the GUID, and that does not seem to be it.

what you have is the id for your package (espacialy regarding the
history of the package).
take a look in the sql help for dtsrun command
in your jobs you can type within teh steps for the command the dtsrun
command like
"dtsrun N/ /E /N "

moby

"Moby" wrote:

> On 21 Aug., 20:45, DTS Newbie
> wrote:
> > I have a sql server 2000 job that is just doing an execution of a DTS pkg..
> > When you look at the syntax in the step of the job I see something like:
> >
> > DTSRun /~ZO4858C301ABE2
> >
> > The problem is, my DTS packages are not named in any uniform way with the
> > Job name, so I don't know which DTS package this job is running. My job is
> > failing, but how can I determine which DTS package it is executing?
> >
> > I looked at the GUID, and that does not seem to be it.
>
> what you have is the id for your package (espacialy regarding the
> history of the package).
> take a look in the sql help for dtsrun command
> in your jobs you can type within teh steps for the command the dtsrun
> command like
> "dtsrun N/ /E /N "
>
> moby
>


I did look up the syntax of the dtsrun command, but there is no default that
is documented. You state that it is the id for the dts package.

The question is, how do I take that dts id and find out which package that
is? Is there a view to query?

I need to know which DTS package is failing in the job.

The /~Z at the beginning of the line means that the data is encrypted. Here is a procedure that will give you the
unencrypted data:

Right-click on the job and then go to Properties, then to Steps
Select the entire line starting with DTSRun and copy to the clipboard
Open a command prompt and paste the line from the clipboard
At the end of the line add " /!Z /!C" (without the quotes). /!Z means "don't execute" and /!C means "copy to clipboard".
Press Return
Open Notepad or any editor and past the clipboard. You will see the unencrypted data, including the package name.

Ed

DTS Newbie wrote:
> I have a sql server 2000 job that is just doing an execution of a DTS pkg.
> When you look at the syntax in the step of the job I see something like:
>
> DTSRun /~ZO4858C301ABE2
>
> The problem is, my DTS packages are not named in any uniform way with the
> Job name, so I don't know which DTS package this job is running. My job is
> failing, but how can I determine which DTS package it is executing?
>
> I looked at the GUID, and that does not seem to be it.
>
>