Ssis-965 -

class FlowBuilder

$schema | ConvertTo-Json -Depth 3 | Set-Content -Path "$FilePath.schema.json" Write-Host "Schema written to $FilePath.schema.json" using Microsoft.SqlServer.Dts.Runtime; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using System.IO; using Newtonsoft.Json.Linq; SSIS-965

// Add OLE DB Destination similarly... pipeline.ReinitializeMetaData(); pkg.Save(); class FlowBuilder $schema | ConvertTo-Json -Depth 3 |

// Locate Data Flow Task (by name) var dfTask = (TaskHost)pkg.Executables .Cast<Executable>() .First(e => ((TaskHost)e).Name == "DF_LoadDynamic"); () .First(e =&gt

var pipeline = (MainPipe)dfTask.InnerObject; var source = pipeline.ComponentMetaDataCollection.New(); source.ComponentClassID = "DTSAdapter.FlatFileSource";