I am using the DTS to import data from an old SQL Anywhere database into a new SQL Server 7.0 database. After I go through all the steps and select 'finish', the wizard will create the tables in the sql 7.0 database but it hangs when it goes to copy the data in. Does anyone have any thoughts. I could write a program and make txt files out of each of the old tables and import them one at a time, but there are a bzillion of them.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trouble importing data form SQL Anywhere
- Thread starter CarolR
- Start date
Similar threads
- Question
