如何通过脚本任务发送ssis中特定文件夹中的文件

using System;
using System.IO;
using System.Net.Mail;
using Microsoft.SqlServer.Dts.Runtime;

namespace SSISPackage
{
    public class ScriptMain : UserComponent
    {
        public override void Main()
        {
            string folderPath = @"C:\Path\To\Folder"; // 指定特定文件夹的路径

            // 获取文件夹中的所有文件
            string[] files = Directory.GetFiles(folderPath);

            // 遍历文件列表，发送每个文件
            foreach (string file in files)
            {
                // 创建邮件对象
                MailMessage mail = new MailMessage();
                mail.From = new MailAddress("sender@example.com");
                mail.To.Add("recipient@example.com");
                mail.Subject = "File from SSIS";
                mail.Body = "Please find the attached file.";

                // 添加文件附件
                Attachment attachment = new Attachment(file);
                mail.Attachments.Add(attachment);

                // 发送邮件
                SmtpClient smtpClient = new SmtpClient("smtp.example.com");
                smtpClient.Send(mail);
            }

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