SSIS DYnamic Folder Name and SMTP Link

I have an SSIS that works except for one small piece.

I build CSV files with dynamic folder names and file names all tied to date and time.

I send an email with a link to the new file

The folder name is set as a variable and "updated" in the process.

Here's the issue.
The folder name is on a shared folder on the network and it has spaces in it.

If I handle that in the path with %20 then the folder is created incorrectly...

If I just leave the space in the folder name then the LINK is broken at the space.

Any ideas?
Is there a way to send an HTML Link in the SMTP Connection?

Its the strFolderName user variable that's the issue below

Who is Participating?
Brendt HessConnect With a Mentor Senior DBACommented:
You can send HTML mail from within an SSIS package, but it uses a script task to do this (which you can see in This article on  

You also have the option of reformatting the link string for two different uses.  For folder creation, leave the spaces in the expression.  For setting the link in the email, create a different expression that replaces the spaces with %20, so the link sends and functions correctly.
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.