Re: Accessing SSIS package

2008-04-21 Thread Phil Cruz
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 >

Re: Accessing SSIS package

2008-04-20 Thread Bruce Sorge
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 > > > > ~~

Re: Accessing SSIS package

2008-04-20 Thread Bob Clingan
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 trigge

Re: Accessing SSIS package

2008-04-20 Thread Bob Clingan
>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, >

Accessing SSIS package

2008-04-19 Thread Bruce Sorge
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