Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to configure Audit Transformation Expand / Collapse
Author
Message
Posted Monday, August 25, 2008 4:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, January 28, 2009 10:48 AM
Points: 15, Visits: 97
Dear All

I want to add following columns in my audit table
Total Rows inserted correctly
Total Rows that failed to insert
user defined reason (Why it is failed )
Table name to which failure occure

How can I solve this problem.




Post #558034
Posted Monday, August 25, 2008 6:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, July 31, 2010 11:58 AM
Points: 147, Visits: 249
This link will be ur answer...

http://wiki.sqlis.com/default.aspx/SQLISWiki/Row%20Count%20Transformation.html

Thanks!
Post #558079
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse