August 24, 2005 at 5:59 am
All,
I have a problem with a DTS package taking hours to export to a DBF. The task is a Transform Data Task. The Source is a query to a database on the local SQL Server. The Destination is a dBase V file on a local drive on the SQL Server.
The task has been running now for 3 hours, and the destination DBF has gotten to 1GB (which is expected - there are about 8 million rows to export).
However, when I had the task exporting to a TAB delimited text file, the task completed in about 30 minutes.
Does anyone have any suggestions as to why it is taking so long by simply changing the destination from a text file to a DBF file?
-Steve
August 25, 2005 at 8:17 am
Check if there are indexes on the dbf file.
August 25, 2005 at 8:18 am
There are none - I created the DBF especially for the data export, and it is not used by anything else.
August 25, 2005 at 9:22 am
A couple of other items you might look into.
1. does the sql server table have many text files
2. is there a real time virus monitoring program running on the pc and are files with a dbf extension being scanned
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply