I've tried to do this in the past and just gave up. There are all sorts of issues including permissions and ownership. I couldn't get it to work through CF (although our CF was on a different server then SQL, and no AD). It might work if you have AD, but we ended up just scheduling the DTS and running it every hour.
I wonder if you can easily run a SQL server scheduled task through SQL... Russ > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 4:22 PM > To: CF-Talk > Subject: Re: execute a DTS package via Stored Proc? > > Thanks, Dave. Glad you brought you brought up the access issue, I > hadn't thought of that. > > Dave Watts wrote: > >> Is there an easy way to do this? I'm trying to avoid using > >> the command-line route to do this. Seems like that it would > >> be a standard feature of SQL Server 2K to have this built-in. > >> > >> Everything I'm finding on Google is just damn complicated.... > > > > It's not built in. To the best of my knowledge, you can only execute DTS > > packages from Enterprise Manager or using the command-line DTSRUN.EXE > > program. You could, however, use sp_cmdshell to run DTSRUN.EXE, assuming > > your DBA hasn't denied you access or dropped sp_cmdshell. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > > > Fig Leaf Software provides the highest caliber vendor-authorized > > instruction at our training centers in Washington DC, Atlanta, > > Chicago, Baltimore, Northern Virginia, or on-site at your location. > > Visit http://training.figleaf.com/ for more information! > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247553 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
