File name includes file path in DTS Send Mail task - help

I have an issue with a DTS package. We create a zip file and then attach it to emails going out using DTS. The problem is that the attachment, when received, is named using the full path to the file, so it is quite long.

Has anyone seen this before? Is there a way out of this?

I am considering mapping a drive to the share holding the file to be named, but the fact is this will shorten the name but will still result in the path being included.

I am wondering if this is a bug, as I suspect this isn't the default behaviour.

Thank you in advance.

Davehow are you zipping the files? thru some command line statements? I dont think its related to DTS in any way.|||Are you talking about the file names inside the ZIP? or the name of the zip file?|||The files are zipped in a previous step. The values in the send mail step are dynamically set, but basically in the Add... for the attachment you get a path like:

\\computer\folder1\folder2\folder3\longzipfilename .zip

The attached file when received will be:

computerfolder1folder2folder3longzipfilename.zip

It is quite strange. The zip file name is only "longzipfilename.zip", and it is sitting in folder prior to the mail step, so I don't quite get it.

I hope that helps.

Thanks for the replys.|||It is strange, can you paste the send mail statements here? where name of the file is dynamically created.|||Originally posted by rohitkumar
It is strange, can you paste the send mail statements here? where name of the file is dynamically created.

I am stumpted. It looks like the file is displayed properly in Outlook but not in some other email clients, which makes me think this isn't a DTS issue after all. I am not at the site now, but essentially the value for the path of the file is getting passed along in the email. Since this is an intermittant problem (per Windows version or Outlook/Web Mail etc.) I don't believe it is something I can correct with any ease.