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...

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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.