Check the index sizes on the source tables, as they can sometimes be left off the target database when archiving.

You could also investigate the use of Page level compression on the Target DB, which depending on the data profile could reduce the size significantly.

You could also look at putting the Target database on different server with more space then use the scripts that you were going to use as sources for SSIS and have the target as the destination.