Post reply

pass the row count value to send mail task.

  • June 16, 2011 at 2:27 pm

    #238183

    Hello Guys,

    I need to pass the count values by mail.

    I'm selecting count of rows from the table by using SQL execute task. I'm trying to pass the count value to Send mail task with below steps.

    Steps:

    1.created Int32 var in package level

    2.Execute SQL Task -> select count from table ->set Result set .

    3.Send mail task -> select message source type as variable -> passing row count variable.

    but I am unable to send mail while selecting message source type as variable in the send mail task.

    anyone help me out how do pass the row count value to send mail task...

    thanks.

  • June 16, 2011 at 3:27 pm

    #1340093

    Found this.

    http://www.sqlservercentral.com/Forums/Topic462732-148-1.aspx

  • June 17, 2011 at 3:10 pm

    #1340722

    Thanks, ya, i refered the link.but still i'm facing issue.

    My case is like...

    I have created 2 variables data type as int32 in package level scope, which holds the 2 row count values from 2 tables.Just I need to pass this variable(i.e. count values) to send mail task.

    But I’m unable to handle in send mail task. I’m getting message as [Send Mail Task] Error: Variable "User::RowCount_tblFile" is not of type string.

    when I change the Data type variable to String , I will be getting error in Respective Dataflow->row count transform. Since I have changed the Data type of variables(int32 to string).

    Error is like " Error at row_count: the variable "user::var_rowcount" specified by variablename property is not an Integer.

    So how to handle such issue.

    I just want to send 2 variable count value to Send mail task. I don’t want to check any conditions. Just I need to notify that this are the count those variables.

    Please help me out.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply