Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Attachments using DTS Send Mail

Status
Not open for further replies.

TallGuyinIT

IS-IT--Management
Oct 18, 2004
34
US
We have a DTS package in SQL 2005 that e-mails a file to a group at the end of processing. The package runs fine and everyone receives the e-mail with the attachment.

The problem is that the attached file has the full file path as its name when it goes to recipients outside our network (//server/folder/folder/file.txt).

Recipients on our network receive the attachment with just the file name (file.txt). Is there a setting or work around so that all recipients get just the file name (file.txt)?

Thanks,
Glen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top