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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.