I am create a DTS package which uses the Data Pump from a text file to a
SQL Table. The text file is tab deliminated. It takes 10 - 15 minutes to
load the text file with 200,000 records. I try using Bulk Insert and it's
a lot faster, but on the production servers we are not allow to use it unless
we have admin rights. What are some solutions to improve the DTS package.