When you say that you have different file formats and file structures, you can leverage the following to design a SSIS package:
Create Dynamic File Connection Manager for all filesUse a For Each Loop to enumerate the file system directory to pick up the file and load the file onto the tablesInclude a cleanup task to remove the file after successful load operation