Any Thoughts?

[zatch]

Hello -

I'm using SSIS to download/process text files. I have a 99% completed project. There is one small step which I cannot figure out how to do. I'm hoping you have some suggestions.

When a file fails to process or has validation errors, I want to e-mail a user group and notify them with a link to the file (on the LAN) which is failing. I have this working fine, except that I don't know how to make the location of the file a hyperlink. Outlook attempts to create a hyperlink automatically when the message comes in, but this does not work because some of the file names will have empty spaces in them. So, Outlook ends up with partial links (half of the address is linked, but everything after the empty space is plain text.)

Any ideas?

Thanks.

Mitch

 

[mrdenny]

Put the path and filename in double quotes. This should tell outlook that it's a path and allow it to hyperlink it correctly.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[zatch]

Thanks for your reply, Denny.

Unfortunately, this does not work. It just adds the double quotes and yields a partial hyperlink like before.

Mitch

 

[mrdenny]

Well that's just annoying.

How are you sending the email?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[zatch]

I'm using the Send Mail Task and pulling the MessageSource by using a variable. I also tried your double-quote suggestion by using the direct input option of the MessageSourceType property.

Mitch