I've been writing an ETL that pulls in data from Excel files into a SQL Server database. The original (working) program was written in Visual Studio 2019 and is being moved over to a Visual Studio 2017 environment.
For Loop:
It has the following settings:
The code looking for the file is:
The for loop then goes through a Excel Source -> OLE DB Destination setup for one file
Last but not least, it resets the @[User::FileExist] = 0.
The for loop with execute until it find the first file, does its work per the contents of the loop and then exits out without continuing to check. The loop works in the 2019 edition, but not the 2017 edition.
Any help or ideas of where to look would be appreciated.