Friday, March 30, 2012

Log of rows inserted/updated/deleted

HI, I am wondering if it is possible to retreive this information without using row count transform. Can I get the # of rows inserted/updated or deleted by destination from the log?

Thank you,
Ccote

An OnInformation event is raised by the data-flow task when data flows into a destination. This has free text which contains the number of rows. You would have to parse that information out of the text within the OnInformation eventhandler. See here for more details: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=372847&SiteID=1

-Jamie

No comments:

Post a Comment