Send email task
I need to send an email in my SSIS package. The message body will have a directory path. The receiver will just click the link folder path and he will be able to access the folder.
Look the message will be:
The Job succeeded. The file is located at:\\Serv1\filepath\Data
-------------------
How can I send this part: \\Serv1\filepath\Data as a link so that the receiver can click this link and open up the folder\file. Now I can write down the path but it shows up just as normal
text and no link. Thanks.
April 25th, 2012 7:23am
It's pretty easy with a script task:
http://msdn.microsoft.com/en-us/library/ms403365.aspxMCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2012 7:38am
what is the html tag for a hyperlink to show a directory path as a link. what will be the tag for the following message body?
The file is located at:\\Serv1\filepath\Data
--------------Only the folder will have a link. Thanks
April 25th, 2012 7:59am
<a href="file://\\Serv1\filepath\Data">\\Serv1\filepath\Data</a>
MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
April 25th, 2012 8:01am
string
smtpConnectionManager = Dts.Connections["SMTP Connection Manager"].ConnectionString;
-----This is not working. giving me null. I tried to use directly smtpserver="orgnsmtp"---this is the name of our smtp server --did not work either
April 25th, 2012 9:17am
If you haven't figured this out yet, try a call to Dts.Connections["SMTP Connection Manager"].AcquireConnection to get
the connection string, or (string)Dts.Connections["SMTP Connection Manager"].Properties["SmtpServer"].GetValue(Dts.Connections["SMTP Connection Manager"]) to get just the SMTP server name.
Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
May 14th, 2012 2:09pm