Untitled

public void Main()
{
    string username = Dts.Variables["$Package::user"].Value.ToString();
    string password = Dts.Variables["$Package::pwd"].Value.ToString();
    string URL = Dts.Variables["$Package:URL"].Value.ToString();

    WebRequest request = WebRequest.Create(URL);
    request.Credentials = new NetworkCredential(username, password);
    var webResponse = request.GetResponse();
    Stream dataStream = webResponse.GetResponseStream();
    StreamReader reader = new StreamReader(dataStream);
    string responseFromServer = reader.ReadToEnd();

<html>
    <head><title>Index of /file-download/</title></head>
    <body bgcolor="white">
    <h1>Index of /file-download/</h1><hr><pre><a href="../">../</a>
    <a href="20170826/">20170826/</a>                                          27-Aug-2017 00:05                   -
    <a href="20170827/">20170827/</a>                                          28-Aug-2017 00:05                   -
    <a href="20170828/">20170828/</a>                                          29-Aug-2017 00:05                   -
    <a href="ProductDefinitions/">ProductDefinitions/</a>                                26-Aug-2017 16:58                   -
    <a href="file-download-automation.readme.txt">file-download-automation.readme.txt</a>                12-Aug-2017 01:56                1061
    </pre><hr>
    </body>
</html>

var doc = new HtmlDocument();
  doc.LoadHtml(rawHtml);
  var first = doc.DocumentNode.Descendants()
        .Where(_ => _.Name == "a")
        .OfType<HtmlNode>()
        .Select(_ => _.Attributes["href"])
        .Select(_ =>
        {
            try
            {
                DateTime.TryParseExact(_.Value, "yyyyMMdd/", null, DateTimeStyles.None, out var result);
                return (DateTime?)result;
            }
            catch
            {
                return null;
            }
        })
        .Where(_=> _.HasValue)
        .OrderByDescending(_ => _.Value)
        .FirstOrDefault();