Chapter Summary


In this chapter, you learned a number of techniques for incorporating error handling into DTS packages. You added batch control to your packages to enable you to differentiate between executions of the data movement application. You added success and error logging steps into the packages, which record the batch ID value with each log entry into an audit table. Finally, you captured information about the number of rows transformed and the number of rows with errors for each step in each package that modified rows. These techniques enable you to capture additional error information and quickly determine whether you need to review the error logs in detail for any particular execution of the data movement application.




Microsoft SQL Server 2000 DTS Step by Step
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
Year: 2003
Pages: 87
Authors: Carl Rabeler

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net