Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Orphaned Excel Process from DTS problem

Author  Topic  dairec Starting Member 16 Posts Posted - 2006-08-10 : 09:46:04 Hi there, I have a DTS package that imports data from an Excel worksheet into a SQL Server 2000 database. My problem is that once the package completes, it leaves an Excel.exe process running on the client machine from which the package was run. When the orphaned process is running (as seen in Task Manager) and I double-click the transformation in the DTS designer, the Excel process actually becomes visible with the workbook in question open. Any ideas what's going on and how I might ensure that the Excel process is terminated once the package has finished? Thanks in advance, Daire Cunningham