all groups > sql server dts > july 2005 >
You're in the

sql server dts

group:

DTSRun of "SQL Server Objects Task" has "OLEVERB failure"


DTSRun of "SQL Server Objects Task" has "OLEVERB failure" Sparky
7/27/2005 11:15:05 AM
sql server dts:
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




Re:DTSRun of "SQL Server Objects Task" has "OLEVERB failure" UBTJITC3d
9/23/2005 7:46:12 AM
same problem - i'm copying from 1 db to another on the same server. is the
problem 2003 server permissions? i added sdb to administrators and get the
same results...
works fine on my 2k server...
RE: DTSRun of "SQL Server Objects Task" has "OLEVERB failure" Sparky
9/26/2005 11:39:03 AM
Never got a response!

[quoted text, click to view]
AddThis Social Bookmark Button