this might help:
http://www.swynk.com/friends/green/dtsole.asp
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 28, 2001 6:44 PM
To: CF-Talk
Subject: RE: DTS from Stored Procedure MSSQL 7.0
> Is is possible to execute a DTS package from a stored procedure?
The only way I know to do this off the top of my head is to to use
xp_cmdshell to call the dtsrun command-line utility.
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
