dbTalk Databases Forums  

DTS fails when scheduled

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS fails when scheduled in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andre Gibson
 
Posts: n/a

Default DTS fails when scheduled - 01-24-2006 , 12:25 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


Reply With Quote
  #2  
Old   
Andre Gibson
 
Posts: n/a

Default RE: DTS fails when scheduled - 01-24-2006 , 12:46 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:

Quote:
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


Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default RE: DTS fails when scheduled - 01-24-2006 , 02:59 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?clie...-8&sa=N&tab=wg

Allan




Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.