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  Import/Export (DTS) and Replication (2000)  Error in executing DTS packages via SP

Author  Topic  Averno Starting Member 10 Posts Posted - 2001-11-13 : 09:16:13 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