In SSIS package there is execute sql task which connects with script task where it has to pass on a list of email ids, and script task suppose to send a simple email to all those users. But in my case I am getting email from my email to only one another email. Its not email to all the email ids provided by the store proc. The store proc result come in one line separated by semicolon. For result set, there is 0 for result name and user::emailtosend.
In script task I have put readonly variables-User::emailFrom,User::emailGroup,User::emailHost,User::emailHtmlEmpty,User::emailHtmlEmptyMessage,User::emailids,User::emailPassword,User::emailPort,User::emailSubject,User::emailUsername
ReadWriteVariable-User::emailToSend
Any help and suggestion will be really appreciated. Thanks a lot in advance
Submit an article or tip