title: Export Dynamic Excel File with dynamic excel sheet in Sql Server table
body: <p>I have an excel file which keep changing every month (in Aug month it is named 'Aug file', in Sep month it is named 'Sep file', etc.). And in the file two sheets are present named 'Service Aug' and 'Provider Aug' in month Aug, if it is Sep Month, sheets name would be 'Service Sep' and 'Provider Sep'. I have to load this data each month in Sql server table(it will be truncate and load).
  How to do that using SSIS?
  Note-&gt; Every time there will be single file in the folder, if it is Aug month then the file would be 'Aug file', 'Sep file' in Sep month.</p>