I'd like to make 'Excel Connection Manager' in SSIS read every time diffrent file names in every time"Dynamic file name" -


heading ##i faced little issue in ssis in excel connection manager issue :

 moved , renamed excel sheet file in name"cmp_20140309134003.xlsx" in day  after , after come in diffrent name in every time  "cmp_201403010134003.xlsx"  faced error in "ecel connection manager" because connection manager has  specific file name tried creat variable :  1-file_path    c:\cmp_20140309134003.xlsx  2-file_ext     *.xlsx  3-folder_path  c:\  , declare these variables in each loop container , excel connection  properties faced error    way talk source.xlsx name , put variable declare  connection expression.   please how can make excel connection manager read diffrent file name  in every time  suggestions??! :) 

  1. in each loop container select 'variable mappings'
  2. map name of path , file name user variable
  3. right click in connection manager , select 'properties'
  4. click on 'expressions' , ellipsis
  5. select 'excelfilepath' property dropdown menu
  6. click on ellipsis in column expression
  7. select name of variable hold path/filename

enter image description here

enter image description here

enter image description here


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -