Raunak Jhawar (12/17/2013)
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 files
Use a For Each Loop to enumerate the file system directory to pick up the file and load the file onto the tables
Include a cleanup task to remove the file after successful load operation
You are responding to a forum newbie and these are high-level ideas which require some elucidation, in my opinion.
I am no newbie, but still don't have a clue how would create a "Dynamic File Connection Manager for all files" - what is this thing?
You mention the use of a FEL, but do not mention data flows at all. Perhaps you have a single 'Dynamic Data Flow for all files' in mind - if so, I'd like to know more please.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.