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??! :)
- in each loop container select 'variable mappings'
- map name of path , file name user variable
- right click in connection manager , select 'properties'
- click on 'expressions' , ellipsis
- select 'excelfilepath' property dropdown menu
- click on ellipsis in column expression
- select name of variable hold path/filename
Comments
Post a Comment