how to launch the SSIS project via your module?

Aug 20, 2015 at 1:00 PM
I have only this code and that doesn't work
Add-Type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
$ssisApplication = New-Object "Microsoft.SqlServer.Dts.Runtime.Application"
$ssisPackagePath = "C:\users\test\documents\visual studio 2012\Projects\SP\SP\Package.dtsx"
$ssisPackage = $ssisApplication.LoadPackage($ssisPackagePath,$null)
$ssisPackage.Execute()