First I have few questions;

1) What is the data source?

2) What is the destination db type (OLTP / DW)?

3) Is SSIS running on an SQL Server Instance?

Preferably one would use staging area/tables which greatly simplify the import process (ELT rather than ETL) by shifting the DB logic into the SQL Server rather than performing such operations within SSIS. SSIS is a great tool for pumping data and for process execution, it is less than mediocre for relational database logic.

Slight side note, if your SSIS package has many tasks, think of simplifying it by separating those into several packages and execute those from a master package, much easier to maintain. My normal approach is to have a master package which creates and executes each individual task package on the fly reading the logic from configuration tables.

😎