Dynamically creating table based upon the source excel file name and rowset
<p>I have folder, which contains several excel files all files are contains same structure. Now I need to load these excel data of each excel file into different table and the the table need to be created dynamically by using source excel file name and the same schema of the excel.</p>

<p>Like File A need to be loaded to file a table and File B need to be loaded to File b table and the tables also need to be created dynamically through ssis package and if there is any error in one file while loading the data it should not stop there and need to go to next file by leaving the error file in the folder.</p>

<p>Please help me...</p>