DTSRun of "SQL Server Objects Task" has "OLEVERB failure" -
07-27-2005
, 01:15 PM
Run package to execute the 'CopyProcedures' proc as follows:
exec master.dbo.xp_cmdshell 'dtsrun /S (local) /E /N CopyProcedures ' ,
OUTPUT
CopyProcedures contains a Copy SQL Server Objects Task that:
Copies several stored procs from (local) to a destination server
The CopyProcedures executes OK within the DTS layout screen
The DTSRUN post following errors:
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100 |