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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics