private TextReader textReader = null; public override void AcquireConnections(object transaction) { if (ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager != null) { ConnectionManager cm = DtsConvert.ToConnectionManager( ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager); ConnectionManagerFile cmFile = cm.InnerObject as ConnectionManagerFile; string fileConnection = cmFile.AcquireConnection(transaction) as string; textReader = File.OpenText(fileConnection); } } public override void ReleaseConnections() { if (textReader != null) { textReader.Close(); textReader = null; } }