Hy everybody
I've one problem in executing DTS packages via Stored Procedure.
I try executing the followin' in Query Analizer:
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:
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
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
I don't know how to solve this problem, so any help will be greatly appreciated.
Thank you in advance, bye