Post reply

Looping Through Multiple Excel

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply