 | |
SQL 2K job and DTS
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQL 2K job and DTS -
08-21-2008
, 01:45 PM
#2
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#3
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#4
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#5
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#6
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#7
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#8
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#9
| |||
| |||
|
|
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. |
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/ <servername> /E /N <dts_package_name>"
moby
#10
| |||
| |||
|
|
On 21 Aug., 20:45, DTS Newbie <DTS New... (AT) discussions (DOT) microsoft.com 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/ <servername> /E /N <dts_package_name>" 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.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.