Duh! I should have known that. I guess I was complicating the issue.
Thanks Susan Phillip B. ----- Original Message ----- From: "Susan H. Allen" <[EMAIL PROTECTED]> > 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]> > > > 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] > > > > 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.
