Remote PPSCMD call from SSIS Control Flow Item to Modeler machine
A while ago I posted a video for using SSIS for PerformancePoint Server (PPS) Planning data integration. Consider also rereading other posts on this. Somebody asked a valid question about how to use PPSCMD remotely from an SSIS Control Flow Item. Well, let me just paste the question here.
We have this server environment for PPS:
· SQL DB and SSIS Box
· SSAS Box
· PPS/IIS box
We have a SSIS package in SSIS box to call Planning command utility:
Does this mean we have to install PPS modeller in SSIS server box in order to run this process?
Answer: NO
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."
-----------------
Here's more info. about PSEXEC (PsTools)
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.
