SSIS Flat File Destination Setting Connection String to variable + string

Question

I'm using SSDT 2016 and Sql Server 2014.

I am outputting a bunch of Flat Files with debug information during my import. For these I use Flat File Connection Managers. I have a project variable DebugOutputFolder.

I can't figure out how to set the Flat File Connection String to: @[Package::DebugOutputFolder] + "file1.csv".

Does anyone know how to specify that?

Answer 1

Find the Connection String property of the Flat File's connection manager, and click the ellipsis (...) button and create an expression.