Re: Accessing SSIS package
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
Re: Accessing SSIS package
Thanks Bob. Bruce On Sun, Apr 20, 2008 at 10:25 AM, Bob Clingan wrote: > 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 > > > > ~| 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:303833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Accessing SSIS package
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
Re: Accessing SSIS package
>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:303831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Accessing SSIS package
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:303809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
