> 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:247548 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
