Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error on executing DTS via SP

Status
Not open for further replies.

davideart

Programmer
Apr 4, 2001
55
IT
Hy everybody
I've one problem in executing DTS packages via Stored Procedure.

I try executing the followin' in Query Analizer:

Code:
EXEC master..xp_cmdshell 'dtsrun /S <servername> /U <username> /P <userpassword> /N <dtspackagename>  /M <dtspackagepassword>'

The previous script work properly on a certain server, but if I run it on another server (on which, of course, the DTS package is also defined) what I receive back is the followin' output:

Code:
DTSRun:  Loading... 
DTSRun:  Executing... 
DTSRun OnStart:  Copy SQL Server Objects 
DTSRun OnProgress:  Copy SQL Server Objects; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0 
DTSRun OnError:  Copy SQL Server Objects, Error = -2147024893 (80070003) 
   Error string:  The system cannot find the path specified. 
 
   Error source:  Microsoft Data Transformation Services (DTS) Package 
   Help file:  sqldts80.hlp 
   Help context:  1100 
 
Error Detail Records: 
 
Error:  -2147024893 (80070003); Provider Error:  0 (0) 
   Error string:  The system cannot find the path specified. 
 
   Error source:  Microsoft Data Transformation Services (DTS) Package 
   Help file:  sqldts80.hlp 
   Help context:  1100 
 
 
Error:  -2147024893 (80070003); Provider Error:  0 (0) 
   Error string:  The system cannot find the path specified. 
 
   Error source:  Microsoft Data Transformation Services (DTS) Package 
   Help file:  sqldts80.hlp 
   Help context:  5700 
 
 
Error:  -2147467259 (80004005); Provider Error:  0 (0) 
   Error string:  [SQL-DMO]Cannot set C:\Programmi\Microsoft SQL Server\80\Tools as the current directory.The system cannot find the path specified. 
 
   Error source:  Microsoft SQL-DMO 
   Help file:  SQLDMO80.hlp 
   Help context:  1132 
 
DTSRun OnFinish:  Copy SQL Server Objects 
DTSRun:  Package execution complete. 
NULL
Have I to reinstall the SQLDMO.dll library?
I don't know how to solve this problem, so any help will be greatly appreciated.

Thank you in advance, bye
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top