April 2, 2018 at 8:31 pm
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
April 2, 2018 at 10:37 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply