I have QB 2004 Premier Professional Services Ed.  I have the most current QODBC driver.  When I use the vb app that comes with the driver, I can query the QB data very quickly.  When I set up a link table in MS Access and write the SQL in the Query section, I can also query the database very quickly.  When I go into SQL Server 2000 and create a DTS job to query all tables from the QB database via the QODBC driver and import them into a SQL Server database, it takes forever to run each query.  The Invoice table ran for 2 and 1/2 hours before completing.

Is there some setting in DTS or something that I'm missing?  All other tools seem to query the QB database very rapidly, whether i use the optimizer or not.  DTS is so slow it is not useful.

The real way to do this is to first optimize your tables by using the [ Load Updated Data ] or [ Reload All Data ] (if you have just started using QODBC) option in the QODBC setup screen.

Once optimization is completed (the time this takes is dependent on the size of your company file), use queries, not copy tables, with the NOSYNC command in the DTS Import/Export Wizard:

like this for each of the tables you wish to import:

select * from Invoice NOSYNC
select * from InvoiceLine NOSYNC

This worked perfectly.  Keep in mind that in the DTS, make sure to run only one query at a time.  By default, if you don't chain these together to run one after the next, DTS runs 3 or 4 concurrently and it takes a LONG time.

I have a DTS Package built to import all tables using QODBC into SQL Server.  Would you like me to send this to you as either a downloadable thing to save people a few hours?