SSIS processes data row-by-row. That's going to be slow.
I suggest using the command line utility bcp. It's been several years, but I've used BCP (Bulk Copy Program) for million row inserts while normalizing data. Six million rows in <1 minute. SSIS can't do that.