Data transfer from a view from one database to a table in another database

Data transfer from a view from one database to a table in another database

I am just trying to find out whether this is the right way to do this
task. Any other suggestions to improve this is greatly appreciated.
I have the following on my SSIS package.

Data Flow task and established a OLE DB connection to the source database
where the view is.
Execute SQL task - I am executing a query with a INSERT INTO Destination
Except (all those records that are already there from the source.)
Send mail task is to send out an email.
How to know that the data transfer is successful? So that I can use the
send mail to indicate success or failure.
How to schedule this package so that it runs automatically (Every Tuesday.)