Q

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 first published in May 2003

Dig deeper on Microsoft SQL Server Installation

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close