I'm importing a bunch of FoxPro tables into a SQL 2000 DB, both FoxPro and SQL DBs located on the same server, and they are all importing except for one. The problem is, the table is not listed in the DTS when I use the "copy tables and views from the source database" option, even though I've verified that it physically exists. If I choose "use a query...", the DTS locks up. The worse part is, the table is the main table! I've tried renaming the table, recopying the FoxPro table from the original FoxPro table located on a different server, all to no avail.

Any suggestions?
[email protected]

Are you recreating these tables everytime with DTS, or is this a one-time push to get it over into SQL Server?

I will ultimately want to make two DTS transfers. I am beginning the process of moving a FoxPro exe over to a more modern ASP front end, while at the same time moving the FoxPro data into SQL Server. So the first time I transfer data I just want dummy data to use a I build the front end. Then when I'm ready to roll out the new and get rid of the old, I'll want to get the FoxPro data all over again. Thus two (successful) transfers total. Am I making sense?

Yes. Then when you are get the FoxPro structure over with the first DTS transfer, is the "trouble" table not transferring, or is it transferring but won't let you select it when you want to do the data transfer?

The trouble table appears, in FoxPro (dbf) form, if I were to browse the server using Windows Explorer. However, through the use if DTS, when it comes time to select via checkboxes the tables I want to import, the trouble table does not appear as an option.