If you want to call a CF Web page with SSIS you can: -Use a Script Task, which exposes the capabilities of .NET. -Create a script file, using a language like VBScript, that launches Web pages, and call that script file from SSIS or SQL Server. The Execute Process Task should work, or you can hand it off to SQL Agent using the Execute SQL Server Agent Job Task. -Use the Web Service Task.
-Mike Chabot On Tue, Sep 18, 2012 at 11:57 AM, fun and learning <funandlrnn...@gmail.com>wrote: > > >If it is the CF job that executes the SSIS package, surely the very fact > >that it running is proof that the cf job executed. > > > > > >On Tue, Sep 18, 2012 at 4:35 PM, fun and learning > ><funandlrnn...@gmail.com>wrote: > > > >> > > No it is not the cf job that executes the SSIS job. They are run > independent of each other. I am trying to synchronize them. > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm