January 24, 2013 at 6:46 pm
I have a report (in ssrs 2005) and report server is on ssrs 2008. The report takes 5 min to run and it returns 4 lakhs records. When I export it to CSV, the file size is 32 MB. I created a subscription to send an email with csv file as an attachment and I never the got the email. I created another data subscription to send it to a windows file share and the export csv is never sent to that windows file share. Please help.
January 25, 2013 at 2:01 am
what is the error message on the subscription?
have you set the unattended execution account?
have you set the smtp server to use for sending mail?
does the account the file share subscription is using have rights to write to the file share?
January 25, 2013 at 7:23 am
what is the error message on the subscription?
For subscription sending email, in reportmanager, status says "Mail sent to ......." and I never got the email (checked junk folders as well).
Fpr subscription sending to windows file share, there is no status.
have you set the unattended execution account? have you set the smtp server to use for sending mail? does the account the file share subscription is using have rights to write to the file share? -- With the same account, I have other reports that send emails and also send excel to windows file share.
January 28, 2013 at 1:30 pm
No worries. It was a permission issue and my DBA gave the necessary permissions and it is working fine now.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply