It may be a perms problem. I think when you manualy execute it , it runs
under the logged on username and when it is scheduled it runs under the
mssql service account. I've had that happen with other stuff, just a
thought.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-----Original Message-----
|From: Steven Dworman [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, February 14, 2002 4:52 PM
|To: CF-Talk
|Subject: RE: executing a dts package
|
|
|yes
|
|-----Original Message-----
|From: Darryl Lyons [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, February 14, 2002 4:11 PM
|To: CF-Talk
|Subject: RE: executing a dts package
|
|
|You've set up an SQL Job for running the DTS package I am assuming?
|
|-----Original Message-----
|From: Steven Dworman [mailto:[EMAIL PROTECTED]]
|Sent: Friday, 15 February 2002 7:15 AM
|To: CF-Talk
|Subject: executing a dts package
|
|
|Here's the deal. We have a DTS package that needs to be
|executed on a monthly basis. The problem is that SQL server 7
|can't execute it. It fails every time. If we run the package
|manually it works just fine.
|
|Any ideas?
|
|Thanks,
|
|Steven D Dworman
|---------------------------------------------------------
|Web Consultant
|Systems Administrator
|
|ComSpec International - http://www.comspec-intnl.com
|phone: 248.647.8841
|cell: 734.972.9676
|---------------------------------------------------------
|EMPOWER-XL ***Software for Higher Education***
|http://www.empower-xl.com
|
|
|
|
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
