How to read Excel file name from stored procedure and file path in a variable in ssis

• nhimabindhu

  Ten Centuries

  Points: 1242

  More actions

  October 18, 2012 at 4:02 am

  #264351

  Hi,

  I have few excel sheets in a folder i need to load that sheets in a table the sheet names are coming from stored procedure and i am using the file path is in another variable how to get the both file name and sheet name in one variable in ssis and that sheets data has to load in one table. 🙂

  can any one help ............

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  October 18, 2012 at 4:20 am

  #1550385

  Check the following link may help u

  http://stackoverflow.com/questions/4444169/import-data-from-excel-using-ssis-without-knowing-sheet-name

• nhimabindhu

  Ten Centuries

  Points: 1242

  More actions

  October 18, 2012 at 5:32 am

  #1550411

  Hi ,

  Thanks for reply but in the link which was mentioned the script task has been used TO READ sheet name so without scipt task how to read a file.........

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  October 21, 2012 at 1:56 pm

  #1551186

  It is a little unclear what you want because your post is a bit fragmented in terms of its sentence structures, but you may be able to achieve what you want using SSIS Expressions and SSIS Variables.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato