I'm new on SSIS, so I'm struggling with it now. So, the whole picture I've been thinking is that 1. extracting data which have null value from tables 2. Retrieve the email accouts from the extracted data 3. sending email to their accounts (so, it will be multiple users) I want to 1. extract null data daily basis from my database/cube first, I tried to set variable for defining current date so that the system reads data only for the current date, I set date variable as package, string type "Select getDate()" but it does not work. Is there any other way to get current date? 2. email warning to multiple users who have null data Is it possible to send email to multiple users? If anyone knows, please answer my questions. I will really appreciate it.