Running package from another servers job agent

[Alan0568]

I have deployed a package to sql server(B) msdb. When I schedule the package using the job agent SSIS step on server (B) it will not save the job and errors with 'the specified '@subsystem is invalid'. I assume this is because server (B) does not have SSIS installed (true). If I run sp_enum_sqlagent_subsystems the SSIS subsystem is not present. Other than the obvious (install SSIS) is there a way to get the job agent on server (B) to run the pacakage. I have SSIS on the machine on which the package was designed, but no DB engine and therefore job agent.

I have no access to anything other than the sql instance on server (B)

Thanks in advance.

 

[mrdenny]

Nope, installing SSIS is the only option.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Alan0568]

many thanks