| Author |
DTS fails when scheduled
|
|
| Andre Gibson 2006-01-24, 1:23 pm |
| I built a dts package that executes fine when I manually start it but it
fails immediately (event view says within 1 second) when scheduled. this
package copies elements of a db on the production server to the backup
server.
Help.
Andre
| |
| Andre Gibson 2006-01-24, 1:23 pm |
| I manually ran the dts package directly from the server logged is using out
dummy sql email account (this is a domain user account). Here is ther error I
recieved
Invalid OLEVERB structure [SQL-DMO] Create File error on
server1.my_db_name.LOG.
Does anyone know what this means? How do I get around this?
Thanks again
Andre
"Andre Gibson" wrote:
> I built a dts package that executes fine when I manually start it but it
> fails immediately (event view says within 1 second) when scheduled. this
> package copies elements of a db on the production server to the backup
> server.
>
> Help.
>
> Andre
>
| |
| Allan Mitchell 2006-01-24, 8:24 pm |
| Hello Andre,
When this happens it is usually something to do with the things contained
in this article.
http://support.microsoft.com/?kbid=269074
perhaps it will also help you.
That said this error has been discussed before and this page may be of help
http://groups.google.com/groups?cli...f-8&sa=N&tab=wg
Allan
[color=darkred]
> I manually ran the dts package directly from the server logged is
> using out dummy sql email account (this is a domain user account).
> Here is ther error I recieved
>
> Invalid OLEVERB structure [SQL-DMO] Create File error on
> server1.my_db_name.LOG.
>
> Does anyone know what this means? How do I get around this?
>
> Thanks again Andre
>
> "Andre Gibson" wrote:
>
|
|
|
|