Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: 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.

    Dave

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    how are you zipping the files? thru some command line statements? I dont think its related to DTS in any way.

  3. #3
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Are you talking about the file names inside the ZIP? or the name of the zip file?
    -bpd

  4. #4
    Join Date
    Jan 2004
    Posts
    5
    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.

  5. #5
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    It is strange, can you paste the send mail statements here? where name of the file is dynamically created.

  6. #6
    Join Date
    Jan 2004
    Posts
    5
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •