Another option is to call the sp_start_job stored procedure. http://technet.microsoft.com/en-us/library/ms186757.aspx
-Phil > You should be able to run it using CFEXECUTE to run an app called > DTEXEC.exe. Check out the docs here: > > http://msdn2.microsoft.com/en-us/library/ms162810.aspx > > --Bob > > > >Happy Saturday! > >I created an SSIS package and deployed it to my SQL Server, but what > I am > >trying to figure out is how to trigger it using ColdFusion. Do I need > to > >create an SP or a trigger to do this? I know in the past with DTS > packages > >we would use the CFOBJECT tag to invoke it. > > > >Thanks, > > > >Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4