Dumps the content of SQL Tasks in SSIS dtsx packages to files for easier diff-ing in source control.

ExportSQLTasks.ps1

import-module SSIS
$ssis_package = "D:\MyFile.dtsx";
$package = Get-ISPackage -path $ssis_package;
$package.Executables | Where-Object { $_.InnerObject -like 'Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask' }  | %{ $fn = $_.Name+".sql"; $_.InnerObject.SqlStatementSource > $fn }