You're looking for the dtsrun utitlity<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp>which may be run via cfexecute<http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00000243.htm> ..
I agree with Bryan. You need to figure out why it's not running as scheduled. I assume you're using SQL Server Agent to schedule this package. Go into Enterprise Manager, SQL Server Agent and run this directly. It will probably indicate the reason the job failed. Perhaps SQL Server Agent isn't started? This could also be your problem. On 12/28/05, Mickael Elmalem <[EMAIL PROTECTED]> wrote: > > Hello All, > > I am hoping that someone help me with this one. We have a server in our > local network that synchronizes to a remote website. This is done by a DTS > package running on a machine in our network at scheduled intervals. The > issue is for what ever reason the DTS package that is supposed to run > everyhour does not. If I log on to the machine and run the package it works > then keeps on working. My question is. Is there a way to have a user click > on a CFM page to run a DTS package on the local machine? The idea is that > the staff know right away that the sync is not working and if they could > invoke it, then escalate to IT that would help the service level. > > Thanks. > > Mike > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
