use script task to send emails: a sample:
public void Messager(string MessagingSubjectLine, string Report, string To, string From, string LogFileLocation, string ExecutionSummary)
{
string conn = Dts.Connections["SMTP_Conn"].AcquireConnection(null) as string;
conn = conn.Split(new char[] { '=', ';' })[1];
MailMessage varHTMLMail=new MailMessage();
if (To.Split(';').Length > 1)
{
string[] amto = To.Split(';');
foreach (string s in amto)
varHTMLMail.To.Add(s);
}
else
varHTMLMail.To.Add(To);
varHTMLMail.From = new MailAddress(From);
SmtpClient varSMTPClient;
varHTMLMail.Subject = MessagingSubjectLine + "Completed";
varHTMLMail.Body = Report;
varHTMLMail.Priority = MailPriority.Normal;
varHTMLMail.IsBodyHtml = true;
varSMTPClient = new SmtpClient(conn);
varSMTPClient.UseDefaultCredentials = true;
varSMTPClient.Timeout = 100000 * 6;
varSMTPClient.Send(varHTMLMail);
}
For scheduling packages, create SQL Server Agent jobs and schedule it.
There are many advantages for SSIS, google it.