Hello everyone, I am using BIDS 2005 i want to know is there is anything in SSIS which is used for Rule designer

Hello, Can you please explain more detailed what you mean / with "Rule Designer"?Olaf Helper Blog Xing

Rule designer for emails how to make dynamic email component

There is a Send Mail Task in SSIS available, if you mean this?Olaf Helper Blog Xing

Can you be specific with your requirements. Whats the scenario where you want a Business rules component. A dynamic email component can be achieved via a set of tables and the Send Mail Task (Refer this). For out of box email functionality not supported by the Send Mail task, you can use a script component like here http://btsbee.wordpress.com/

Rule designer for emails how to make dynamic email component you can create your own custom email component if that is what you are asking. If that is the case then your question should be more generic than specific. Can you share you requirement so that we can help you in a better way? Thanks.Please mark the post as answered if it answers your question

Hi Ajay Singh Rawat, You can create an expression for the Subject property and for the MessageSource property in Send Mail Task. You can use the Subject property expression to dynamically update the subject of an e-mail message, you can use the MessageSource property expression to dynamically update variables in the e-mail message, such as variables that are populated by a Row Count transformation. For more information about creating a dynamic subject or message for the Send Mail task, please se: http://support.microsoft.com/kb/906547 Please feel free to let me know if my understanding is wrong. Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.