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.
Is there a way to send an HTML Link in the SMTP Connection?
Its the strFolderName user variable that's the issue below