I have SSIS and DTS packages running locally (VC and SQL on the same box) and it works great.

I need to have VC run an SSIS package on a different server.

When I do this currently I get the error "Error in task execution: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154."

I'm running the package as located in file. I've tried running it as 2 different users, both with admin access on the source and target box.

Any Ideas?

Update - so I mapped a drive to the drive of the machine and now I get this error:

The SSIS Execution failed
From, GetErrorValues (0)

We are using the Microsoft API for executing SSIS packages. The API does not allow remote execution. One way to come around that is to create a SQL Job in your SQL server that calls the SSIS package and then use the SQL Task in VisualCron and choose to Execute Job. That function can execute remote Jobs.

---

Yes, but VC doesn't monitor the job for completion - it runs it then claims success. If the job fails, I don't know.

Correct, the API just allows us to know if the Job was started OK, not if it was completed ok. We see no way of knowing that.

---