calling coldfusion page from SSIS package

Hi All - I have the following scenario 1) Coldfusion page is run as a scheduled job 2) After the above script is run, a SSIS package is run. I want to make sure that the Coldfusion job is successful before running the SSIS package. Is there a way to call the coldfusion job from SSIS package to syncrhonize both the jobs?

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 <funandlrnng10@gmail.com>wrote: ----- Excess quoted text cut - see Original Post for more -----

----- Excess quoted text cut - see Original Post for more ----- 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

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 <funandlrnng10@gmail.com>wrote: ----- Excess quoted text cut - see Original Post for more -----

It would probably be easier to have your CF scheduled job either 1) log an entry in a database table with a success code and timestamp, or 2) write an entry to a text file that SSIS can read.  Then update your SSIS package to check the table or text file for the success code before proceeding. HTH, -Carl

Why not have the CF job call the SSIS package? ----- Excess quoted text cut - see Original Post for more -----

exactly, which is what I thought he said to begin with :-) ----- Excess quoted text cut - see Original Post for more -----