PowerShell
Edit|Remove
############################### 
### With FileName and Path 
############################### 
Add-Type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" 
$ssisApplication = New-Object "Microsoft.SqlServer.Dts.Runtime.Application" 
 
##With Pathname and FileName 
$ssisPackagePath = "D:\Projects\PowerShellDemos\Demo1\Package.dtsx" 
$ssisPackage = $ssisApplication.LoadPackage($ssisPackagePath,$null$ssisPackage.Execute()  
 
 
############################### 
### With SQL Server Store 
############################### 
<## 
Add-Type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" 
$ssisApplication = New-Object "Microsoft.SqlServer.Dts.Runtime.Application" 
$ssisServer = "SERVER10" 
 
$ssisPackagePath = "\File System\PowerShellDemos\Demo1\Package" 
$ssisPackage = $ssisApplication.LoadFromDtsServer($ssisPackagePath,$ssisServer,$null) 
$ssisPackage.Execute() 
##> 
 This is a simple Powershell script to allow for running an SSIS package from Powershell.

 

This allows either a FileName\Path or can call the execute of the SSIS Package from a SQL Server Store.

The requirements vary based upon the type of execution needed.

Did not see this type of execution available so this is a sample.                                                  

Hope it is of use to you...............................................................................................