Ssis-965

// Add OLE DB Destination similarly... pipeline.ReinitializeMetaData(); pkg.Save();

Error 0xC0202009 at Data Flow Task, OLE DB Source [1]: The data type of column "CustomerID" is unknown. Consequences: 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; // Add OLE DB Destination similarly