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;
   }
}

Поделитесь материалом с коллегами и друзьями