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:303832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
