I have a pretty simple process that copies some files from an AS400 to a directory on the same server where my sql 2005 instance lives. I then use an email task to send these files to a client.
However, the email task does not work. I get the following message:
[Send Mail Task] Error: Either the file "BYNSOSR1;BYNSOSR2;BYNSOSR3;BYNSOSR4;BYNSOSR5;BYNSOSR6;BYNSOSR7" does not exist or you do not have permissions to access the file.
Well, the files definitely exist where they are supposed to be so I guess it's a permissions error. However, I have no clue which user would need permissions on that directory. As a test, I gave everyone read permissions and still got this error.
Any suggestions about which user I need to allow read access to the directory where these files exist?
Thanks in advance for any info.
I should say the path info in the previous post was changed so as not to reveal path info. But, the files do indeed exist where the email task expects them to be. I wrote a vb.net app that can email the files from that location just fine using the SMTP client of the .net.mail object hierarchy.|||Well, I never could figure out why the send email task wasn't working. It must have been some sort of permissions issue. I solved the problem by writing a console app in vb.net that sends the email via the net.mail smtpclient. I then run the console app as a execute process task. That sent the email with no problems and was a perfectly adequate way to solve the problem.
No comments:
Post a Comment