title: data transfer from Multiple Excel files to SQL table
body: <p>Need to transfer data from multiple Excel files to a SQL table.
  For instance there are multiple excel files in a folder such as 
  1.INR_08012013.xls
  2.INR_08022013.xls
  3.INR_08032013.xls
  Note: Look at datepart increments in the file_name.</p>
  
  <p>I'm planning to create SSIS package and import data into SQL.
  I know i can import one excel file at a time but i'm planning to do several at a time.
  There could be many excels so i don't want to create multiple SSIS packages for this job.   </p>
  
  <p>I want to create one SSIS package(for multiple excel files) and import the data into SQL.
  Is this possible thru SSIS, Give me some guidance.</p>
  
  <p>Thanks! </p>