Search notes:

Package

The LoadPackage method of Microsoft.SqlServer.Dts.Runtime.Application parses a .dtsx and returns a Microsoft.SqlServer.Dts.Runtime.Package object.

The following PowerShell snippet tries to demonstrate the method. I had to run it in a 32-bit PowerShell session becuase one of the required assemblies was available as 32-bit on the system where I tested this.

add-Type -assemblyname "Microsoft.SQLServer.ManagedDts, Version=13.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91"
add-Type -assemblyName "Microsoft.SQLServer.DTSRuntimeWrap, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

$app = new-object Microsoft.SqlServer.Dts.Runtime.Application

$pkg = $app.LoadPackage('P:\ath\to\the.dtsx', $null)
"Creator:     $($pkg.CreatorName)    (on $($pkg.CreatorComputerName) at $($pkg.creationDate))"

Index