Manage
Learn to apply best practices and optimize your operations.
Benchmarks and best practices for DTS
We are in the beginning stages of using DTS to migrate flat file data to Oracle. Are there any benchmarks for DTS? This data could be over five million rows on a nightly basis. Also, if code is written within the DTS product (Visual Basic, I assume) to do certain logic routines, does this affect performance? Is it a best practice to load data into the destination database after the data has been "massaged," rather than embed the logic during the DTS process?
If there are, they would be posted on Microsoft's Web site. If you are doing pure import of data, five million...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
rows should go in a few minutes. If you are placing code in the middle of the import process, the load rate is going to be highly dependent on the code you place in the middle.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was last published in May 2003
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
Start the conversation
0 comments