RE: executing a dts package
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
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 __ Dedicated Windows 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=coldfusiona 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
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 __ Dedicated Windows 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=coldfusiona 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
RE: executing a dts package
maybe not the fix you were looking for...but you could execute it from CF. www.cfcomet.com has an article by Simon Horwith that steps through this method... http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297- 4E80-92CC7A8907B0A5B2 -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 3:15 PM 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 __ Get Your Own Dedicated Windows 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=coldfusionb 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
RE: executing a dts package
if you go to cfcomet.com and cick the SQL Server link at the top, there are examples and instructions on how to do this with CFOBJECT and COM. ~Simon > Simon Horwith > Allaire Certified ColdFusion Instructor > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 5:46 PM To: CF-Talk Subject: ot: executing a dts package I'm trying to execute a dts package through CF but have only been able to do it through the dtsrun.exe utility and using cfexecute. The problem is the server I need to do this on doesn't have dts installed. Is there anyway I can still execute a dts packaged from this machine? Maybe using a stored procedure? Thanks! Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: executing a dts package
> I'm trying to execute a dts package through CF but have only > been able to do it through the dtsrun.exe utility and using > cfexecute. The problem is the server I need to do this on > doesn't have dts installed. Is there anyway I can still > execute a dts packaged from this machine? Maybe using a > stored procedure? Thanks! Yes, you can execute DTS packages through a stored procedure, although not directly. You can use the extended stored procedure xp_cmdshell to run DTSRUN.EXE on your database server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
