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
>
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
>
>
>
>
~~
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
>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,
>
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
5 matches
Mail list logo