Slowly Changing Dimension

  • Hi,

    How can I capture  number of updates and  inserts done by SCD?

    Cheers

    Deepak

  • You can use the rowcount component which logs the number of rows and assigns the final value to variable. You can then use this variable later to do what you want. (See OnPostExecute Event handler for a nice place to handle logging)

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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