| Author |
DTSRun of "SQL Server Objects Task" has "OLEVERB failure"
|
|
| Sparky 2005-07-27, 1:28 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
| |
| UBTJITC3d 2005-09-23, 9:23 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...
did you get a resolution?
| |
| Sparky 2005-09-26, 8:24 pm |
| Never got a response!
"Sparky" wrote:
> 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
>
>
>
>
>
|
|
|
|