Post reply

Variables in a Data Flow task

  • August 25, 2006 at 8:26 am

    #116472

    Hi all

    I am copying data from an OLE Source to an OLE Destination.

    How can I get the count of rows processed in this Data Flow task?

    Is there a global variable equivalent to @@RowCount one uses in a Stored Proc?

    Thanks

    Michael.

  • August 27, 2006 at 6:59 pm

    #657016

    Michael,

    You need to create a variable yourself - you can make it global or specific scope - and then add a row count task to your data flow between the source and destination.  In the rowcount task properties you assign the variable you created to it.  I use this method to track all my imports.  I create global variables, eg @ProductCount, @CategoryCount, etc.,  and then call those variables in a send mail task to let me know how many rows were imported by the package.

    Hope this helps.

    Best Regards
    Terry

  • August 28, 2006 at 7:22 pm

    #657225

    Thanks mate . much appreciated. I will try it in the morning.

    cheers...

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

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