See my reply m8, that worked for me. -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: 24 July 2006 21:33 To: CF-Talk Subject: RE: execute a DTS package via Stored Proc?
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:247580 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
