To call PPSCMD from SSIS, you do NOT need to install PPS modeller in SSIS server box.
Barry Tousley, one of Microsoft PerformancePoint Server's great tester provides the following:
"Are you able to change the SSIS command so that it can do a “remote PPSCMD” call to the Modeler machine, (you can do this using a tool called ‘PSEXEC’, (http://www.microsoft.com/technet/sysinternals/utilities/psexec.mspx))? If so, you could have the SSIS package use PSEXEC to execute PPSCMD remotely from the Modeler machine. Is that an option?
If not, you can always just install Modeler on the SQL Server, IIS is not required for Modeler, (so that won’t compromise your SQL Server’s security), and it’s a small footprint as well. And just because it’s installed on the SQL machine doesn’t mean you have to let people use that particular Modeler install, just let the account that’s executing the SSIS package use that one. J
You’ll also want to change the Arguments so the SERVER string isn’t “localhost”, but instead actually points to the FE Server machine."
------------------------------------------------------------------------
PsExec is part of a growing kit of Sysinternals command-line tools that aid in the adminstration of local and remote Windows NT/2K systems named PsTools.
Click here to download.
