Concatenate Environment Variable to File Name
There are many variations of this problem: I want to take the value of an environment variable (a path, ie, "C:\SSIS\Logs\") and concatenate that to the name of my log file (ie, log.txt).
If I go into the Logging menu, I can select my log file (log.txt), no path.
If I go into the Package Configuration menu, I can create the reference of the environment variable to the Target Object ConnectionString for log.txt file. That sets the path (C:\SSIS\Logs\) but no file name.
The end result needs to be set the following value: C:\SSIS\Logs\log.txt
So, what am I doing wrong? I'm trying to avoid using a config file because then I'd have to create an entry for each package.
Please Vote &/or "Mark As Answer" if this post is helpful to you. Thanks and happy coding :D
May 16th, 2012 12:55pm
Hi, you should add another variable and set it's value to an expression that will concatenate both variables. See some examples in these links:
SSIS: Evaluating variables as expressions
SSIS Variable and Expressions Followup
David.
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2012 12:59pm
Ok, I see. I use the Package Configurations Organizer to assign the Environment variable. I was almost there. Thanks!Please Vote &/or "Mark As Answer" if this post is helpful to you. Thanks and happy coding :D
May 16th, 2012 4:23pm


