SQL Server Performance

How to assign values from dataflow results to user-defined variable?

Discussion in 'SQL Server 2005 Integration Services' started by ahn0212, Feb 24, 2009.

  1. ahn0212 New Member

    Basically, I want to get Email Accouts whose working hour is null so that SSIS sends email to them informing them that they did not submit hours.
    Here's my approach for this.
    Through Data Flow, I extracted Email Accounts with null values by conditional split.
    And I thought I should use variable to get the extracted Email accounts in order to automatically send emails to them.
    But I am stuck on assigning these extracted emails to user-define variables.
    Again, the variable should have extracted values, not all values in a table.
    And how to use foreach loop container and Script Component to send emails to all of each user who have null values?
    If anyone has any idea, please help me.
    I will really appreciate.

Share This Page