Looping Through Multiple Excel

• ringovski

  Hall of Fame

  Points: 3526

  More actions

  April 2, 2018 at 8:31 pm

  #330244

  Hi All,
  Hope someone can assist.I am using VS 2017 to try to loop through multiple excel files that a download from email each day. I have looked at multiple guides on the internet and I can't get the excel connection to accept the folder\file name for the excel files.

  Source Folder: C:Excel Files\Asia Sales
  Variables:
  Asia_FileName, String
  Asia_FolderSource, C:\DSM Excel Files\Asia Sales\

  Foreach File Enumerator, Expression, Directory: @[User::Asia_FolderSource]
                                          , Variable Mappings:User:: Asia_FileName

  Excel Connection, Excel Asia File, Expression: Excel File Path @User::Asia_FileName
  Data Flow Task has Delay validation set to true.

  If I remove the expression from the excel connection the warning goes away. The actual screen shots are attached.
  Thanks

• ringovski

  Hall of Fame

  Points: 3526

  More actions

  April 2, 2018 at 10:37 pm

  #1985230

  I worked it out, both the source folder and source file variables have to resolve before running in the loop. So run the file variable with a file before adding other files.