Include dynamic file name

Heiko Oberdiek Heiko Oberdiek k 21 21 gold badges silver badges bronze badges. Add a comment. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hi, I am trying to get the content of a csv-file. I tried to include the variable in the file-path: I also tried to use "concat" to get this done: Any help is appreciated. Labels: Labels: Button Flows. Message 1 of 2. Accepted Solutions.

Message 2 of 2. Post Reply. Helpful resources. Launching new user group features Learn how to create your own user groups today! Learn More. View Now. View All. Just map ExcelFilePath property of your Excel connection manager to variable getting the filename inside the For Each loop and it will iterate through the files.

Otherwise you can just have a EXcel connection manager which points to the single file available and execute.

But in that case its static and wont automatically iterate through the files when there are multiples present or when the file name changes per day.

If you've setup the loop and configured the variable inside then it will get filename automatically during each iteration. Based on the value it gets, the above expression calculates the value for the other variable you created.

If you're using this new variable to set connectionstring for any connection manager make sure you set Delay validation to true so that it doesnt break due to the unavailability of a valid value at design time.

The actual will get calculated correctly only at runtime. This can be beneficial to other community members reading this thread. Sign in.