Home Forums Data Warehousing Integration Services Sent Mail task RE: Sent Mail task

  • July 9, 2014 at 5:05 am

    #1727984

    annam.dba (7/9/2014)

    Hi Lempster,

    Rowcount transformations i can used between source and destination. where can i mention user-defined variables and where can i refer those variables in Send Mail task. Please let me know with screen shots if it passably. I am SQL DBA admin i don't know much in SSIS.

    Thanks,

    Babu

    When you use a Rowcount transformation, you have to store the result (i.e. the row count) in a user-defined variable so set up a variable first (you may need to go to the View menu in BIDS and slect 'Variables' in order to be able to see/add variables) and then reference that variable when you use your Rowcount transformation.

    To use the same variable in a Send Mail task, you need to set the contents of the email message using an Expression.

    Sorry, I don't have the time to provide a detailed explanation with screenshots - have a look at the link I provided in my earlier post.

    Regards

    Lempster