Hi, I have a Powershell Script that needs to be used in a SSIS package. For what I read a solution is to use a Execute Process task and in the expression I use SSIS variables that contains the parameters values, I saw this link http://mark-wbi.livejournal.com/3425.html In the Executable expression I put the path of poweshell.exe file (c:\windows....\v1.0\powershell.exe Let's supose that my ps1 file is in C:\tem\file.ps1 and the parameters are: "ServerName" "SSASCubeName" "C:\Input" "C:\Destination" The script make a ssas cube restore and mode the backup file from the input path to the destination path. How should I write my argument expression in the Execute Process task ? Thanks

I tried in the Arguments expression this: "Powershell -ExecutionPolicy RemoteSigned -File " + @[User::Script] + " " + @[User::Cube_Server] + " " +@[User::Cube] + " " + @[User::Input_Path] + " "+ @[User::Output_Path] Works fine Thanks

@MJGomes - thanks for posting your solution - works a treat. - I was tearing my hair out trying to work out how to do this!