我创建了一个SSIS包，它使用C#脚本从HTTPS URL下载CSV文件。从Visual Studio执行时一切正常。
但是，当我建立SQL Agent作业时，封装会失败。如果我直接从SQL Server执行.dtsx档案，封装也会失败。
错误为
“下载失败：从服务器获取的SSL证书响应无效。无法处理请求”
我已测试从SQL服务器打开URL，并可以查看文件。我还在C#脚本中添加了代码以忽略证书错误，但这似乎没有任何影响。我还在连接管理器中输入了托管CSV的服务器的登录凭据，但这也没有帮助。
CSV是通过Magento数据源生成的。在网站上，所有内容都被重定向到HTTPS。
我在这里迷路了，所以希望有人能好心地帮助我。
下面是C#脚本的片段：

public void Main()
    {
        // TODO: Add your code here
        try
        {

            // Ignore certificate warnings
            ServicePointManager.ServerCertificateValidationCallback =
                 new RemoteCertificateValidationCallback(delegate { return true; });

            // Disable server certificate validation.
            //ServicePointManager
            //    .ServerCertificateValidationCallback +=
            //    (sender, cert, chain, sslPolicyErrors) => true;
            //ServicePointManager.ServerCertificateValidationCallback = (sender, cert, chain, sslPolicyErrors) => true;

            //System.Net.ServicePointManager.ServerCertificateValidationCallback =
            //delegate (object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors)
            //{ return true; };

            // Logging start of download
            bool fireAgain = true;
            Dts.Events.FireInformation(0, "Download File", "Start downloading " + Dts.Connections["TEST"].ConnectionString, string.Empty, 0, ref fireAgain);

            // Get your newly added HTTP Connection Manager
            Object mySSISConnection = Dts.Connections["TEST"].AcquireConnection(null);

            // Create a new connection
            HttpClientConnection myConnection = new HttpClientConnection(mySSISConnection);

            // Download file and use the Flat File Connectionstring (D:\SourceFiles\Products.csv)
            // to save the file (and replace the existing file)                
            String filename = Dts.Variables["varFullPathScript"].Value.ToString();
            myConnection.DownloadFile(filename, true);

            // Logging end of download
            Dts.Events.FireInformation(0, "Download File", "Finished downloading" , string.Empty, 0, ref fireAgain);

            // Quit Script Task succesful
            Dts.TaskResult = (int)ScriptResults.Success;
        }
        catch (Exception ex)
        {
            // Logging why download failed
            Dts.Events.FireError(0, "Download File", "Download failed: " + ex.Message, string.Empty, 0);

            // Quit Script Task unsuccesful
            Dts.TaskResult = (int)ScriptResults.Failure;
        }

        Dts.TaskResult = (int)ScriptResults.Success;
    }