Project parameters and package variables

elsvieta 416 Reputation points
2022-01-27T01:06:32.013+00:00

Hi all,
I am trying to complete an SSIS project that has three packages.
The end goal is to have the project deployed to the SSIS Catalog and use the appropriate configuration for a few different environments when setting up Agent Jobs on said environments.

My setup is as follows:
I created a Project parameter for the Database Connection.
I created a Project parameter for the path to three different input files.
I created a Package variable that holds the name of the file.

What I am trying to do is have the ability to set up the name of the server for the Database Connection (or rather the whole Connection String when configuring),
and the same for the input file path.
What is different among the three packages is the name of the file.

However, when going back to the (project)flatFileConnection which does have the hardcoded file name appended, I cannot express this connection string using the project parameter and adding the package variable, so that I have something like @[$Project::flatFilePath_ConnStr] + @[$Package::varFileName].

I guess I can hardcode the name of the file, but it is a way to combine project params and package variables?

I am sure I am missing something but I can't figure it out.

Thanks,
elsvieta

SQL Server Integration Services
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.