MS explanation :
The information in this article applies to:
Microsoft SQL Server version 7.0
Microsoft SQL Server 2000
--------------------------------------------------------------------------------
BUG #: 55469 (SQLBUG_70) BUG # 203186 (SHILOH)
SYMPTOMS
If you are using a Microsoft Excel file as either the source or destination when you try to import or export data using the DTS Import Wizard, do not open the Excel file while the Import Wizard is being executed. If you do it might result in the following error message:
Catastrophic failure
If you are running the DTS Wizard from within the SQL Server Enterprise Manager (SEM), SEM will be locked. If you are not running it under SEM, the DTS Wizard might either lock up, or report an Access Violation and quit.
Eric De Decker
vbg.be@vbgroup.nl
License And Copy Protection AxtiveX.
Download Demo version on my Site: