I appreciated you article on SSIS. It is timeconsuming to use SSIS in a lot of situations like yours.

You might be able to eliminate SSIS completely. You can use xp_cmdshell to run operations like ftp directly on the operating system. You can also unzip. Just build the commands you want.

Use insert / exec to pull the directory contents into the stored procedure.

Use bulk insert to load data into a database table. The format file option is great for fixed length records and the fastest way I know to load data.