Chapter Summary


In this chapter, you learned about a number of advanced DTS package and task options that you can use to develop a data movement application. You also learned that, due to both performance limitations and task restrictions, transactional control will not be utilized in the prototype of the data movement application you are building throughout the course of this book. Finally, you learned how to capture error rows, which enables you to configure the packages in the data movement application to continue inserting good data rather than fail the entire package. The InsertCommitSize and MaximumErrorCount properties of the Transform Data and Data Driven Query tasks enable you to determine how many errors your application will tolerate before the package fails. In the next two chapters, you will learn how to configure the data movement application so that you can dynamically set task properties at run time.




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

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