DTS Import Wizard - crash???

[nikka]

I am running the desktop version of SQL 7. When I run the Import Wizard to Import a text file, as I click FINISH on the final stage my program hangs. I have uninstalled,reinstalled, formatted and now come to the conclusion that it is a bug in the program.

Any suggestions on a patch to solve this problem or a work around? Preparing for final MCSD subject.

Thanks

 

[link9]

I have encountered this problem before if the tableName of the table I'm trying to import is the same as another existing database object --

No error message(s) will be displayed. It will just stop.

hope that helps
Paul Prewett

 

[shaminda]

I had the same problem when I tried to execute a DTS package on my desktop edition of SQL 7.0. I ran it on our SQL Server with admin rights and it ran fine. So I thought the problem was, I didn't have rights to run the package. Check your security rights. If you have full rights you might be able to run it. If you have a server run it on the server. I don't think it crashed because of a bug.