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

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

Other recent topics Other recent topics