I just through together an article which shows how you can invoke a DTS package via SQL using a couple of stored procedures:
http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS -Dan > -----Original Message----- > From: jon hall [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 4:07 PM > To: CF-Talk > Subject: Re: CF executing a DTS package for a MS SQL server > > http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7836 > Figure 4 shows a vbscript example that should be easy to port, whether > or not CF can handle it is another thing all together... > The DTS object model is kinda VB biased. > > btw, Lumigent was offering a free DTS Object Model poster not too long > ago. I got mine hanging on the wall in my office now. I found this > page via Google...they may still have some :) > > http://www.lumigent.com/go/sqlcentral05/ > > -- > jon > mailto:[EMAIL PROTECTED] > > Friday, February 14, 2003, 3:20:23 PM, you wrote: > JB> Hello All: > > JB> Does anyone have an example of CF executing a DTS package for a MS SQL > JB> server via a COM object through the CFOBJECT tag? > > JB> Regards, > JB> James Blaha > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
