SQL 2K job and DTS

#21

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:

Quote:

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.

#22

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:

Quote:

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.

#23

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:

Quote:

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.

#24

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:

Quote:

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.

#25

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:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2K job and DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SQL 2K job and DTS - 08-22-2008 , 09:12 AM

Re: SQL 2K job and DTS - 08-22-2008 , 09:12 AM

Re: SQL 2K job and DTS - 08-22-2008 , 09:12 AM

Re: SQL 2K job and DTS - 08-22-2008 , 09:12 AM

Re: SQL 2K job and DTS - 08-22-2008 , 09:12 AM