Using SSIS package configuration to change file path?

Question

I want to use the SSIS package configuration to change the path to multiple flat file destinations, but only the path, not the file name. Basically, I have many flat files that go to the same directory, but each has its own name. Unfortunately, a property on a flat file object includes both the file name and the directory as a single line. I would like to configure it, so it’s easy to change the directory for everyone, but where they still have their own unique file name.

Any ideas? Can this be done with an expression?

Answer 1

Yes, this can be done using expressions.

• Define a package variable for a path
• Define an expression for ConnectionString with @[User:Path] + "\filename"
• Use the package configuration to define the variable (or on the command line)

I do not have SSIS on this PC, so no screening, sorry. Check this one and this one though