Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: