Yes, create a dts package incorporating the "Execute SQL Task" task type; the sql statement will be "execute [usp_whatever]". Then schedule the package.
----- Original Message ----- From: "John Wilker" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 8:34 PM Subject: RE: Run Stored Proc in DTS? > You could schedule an agent to run I believe. > > John Wilker > Web Applications Consultant, Writer > Macromedia Certified ColdFusion Developer > Founder/President IE CFUG > www.red-omega.com > > Whatever is wrong it is better than a poke in the eye with a sharp > stick. Unless of course you just got poked in the eye with a sharp > stick. > > > -----Original Message----- > From: Phillip B [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 11, 2003 2:39 PM > To: SQL > Subject: Run Stored Proc in DTS? > > > Can I run a stored proc in a dts package? I have been looking all over > and can't find anything about it. If not is there a way of scheduling a > stored proc to run? I'm trying to avoid calling to it from a CF page. > > Phillip B. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
