Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Error in executing DTS packages via SP

Author  Topic  Averno Starting Member 10 Posts Posted - 2001-11-13 : 09:15:03 Hy everybody I've one problem in executing DTS packages via Stored Procedure. I try executing the followin' in Query Analizer: 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: 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