Ssis-965 | Best & Top-Rated

// Load schema JSON var schema = JArray.Parse(File.ReadAllText(schemaFile)); foreach (var col in schema) var input = source.InputCollection[0]; var colMeta = input.InputColumnCollection.New(); colMeta.Name = col["ColumnName"].ToString(); colMeta.DataType = DataType.DT_WSTR; // Map to DT_WSTR for nvarchar colMeta.Length = 4000;

// Configure source connection (assume connection manager already exists) var cm = pkg.Connections["FlatFileConn"]; source.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(cm); source.RuntimeConnectionCollection[0].ConnectionManagerID = cm.ID; SSIS-965

$schema = @() foreach($col in $headers) $schema += [pscustomobject]@ ColumnName = $col.Trim() DataType = 'nvarchar(4000)' # default, can be refined later Nullable = $true // Load schema JSON var schema = JArray

contains an additional column Region at the end: var colMeta = input.InputColumnCollection.New()