Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How to send email via SSIS package?

Author  Topic 

Fateme
Starting Member

13 Posts

Posted - 2010-09-14 : 02:02:38
Hi everyone,
I've created a SSIS package to create some data sheets in one excel file and now I want to send this file to some email addresses.
I've used send mail task in my package.
The number of email address is 15 and when I put all of them in To address, I can see that send email task sends the email just to 7 address and it cannot to send to all of them.
I would like to know is there any restriction in numbere of email address(or number of characters that I can set in To address)?

I'll appreciate for any help.

Regards,
Fateme

Fateme
Starting Member

13 Posts

Posted - 2010-09-14 : 02:08:34
I've find that The To, Cc, and Bcc lines are limited to 256 characters each in accordance with Internet standards.
I've created a group for all the email address, but I do not know why it does not work, I mean the task cannot send any email to that group.
Please let me know if you have any idea.

Thanks,
Fateme
Go to Top of Page
   

- Advertisement -