internal static ISBaseFlatFileConnectionManager GetConnectionManager(string connectionManagerName, ISProject ssisProject = null, ISPackage ssisPackage = null) { ISBaseFlatFileConnectionManager connMgr = null; if (ssisProject != null) { foreach (ConnectionManagerItem cmi in ssisProject.ConnectionManagerItems_m) { if (cmi.ConnectionManager.Name == connectionManagerName) { connMgr = (ISBaseFlatFileConnectionManager)cmi.ConnectionManager; } } } return(connMgr); }
/// <summary> /// ctor that accepts the parent flat file connection manager and a name for the flat file column /// </summary> /// <param name="fileConnection"></param> /// <param name="name"></param> public ISFlatFileColumn(ISBaseFlatFileConnectionManager fileConnection, string name) { bool exists = false; _parentConnectionManager = fileConnection; foreach (runTimeWrapper.IDTSConnectionManagerFlatFileColumn100 column in fileConnection.Columns_m) { if (((runTimeWrapper.IDTSName100)column).Name == name) { exists = true; FlatFileColumn = column; } } if (!(exists)) { FlatFileColumn = fileConnection.Columns_m.Add(); Name = name; } }
/// <summary> /// Extended ctor that also accepts whether the column is hte last column or not. /// </summary> /// <param name="fileConnection"></param> /// <param name="name"></param> /// <param name="isLastColumnInFile"></param> public ISFlatFileColumn(ISBaseFlatFileConnectionManager fileConnection, string name, bool isLastColumnInFile) : this(fileConnection, name) { IsLastColumnInCollection = isLastColumnInFile; }