System.Runtime.InteropServices.COMException when schedule DTS

[hdamis]

I am trying to schedule working DTS in sql server 2005 sp 2 . but I it failed and got this message . I searched at Internet and found this

http://support.microsoft.com/kb/904796

and I did but still the problem exist any one can help please .

Message

Executed as user: ComputrName\Administrator. ...00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:16:11 ? Error: 2007-08-17 22:16:12.95 Code: 0x00000000 Source: Copy Data from ROOM to DBName dbo ER_ROOM Task Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread() End Error Error: 2007-08-17 22:16:14.75 Code: 0x00000000 Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread() End Error Error: 2007-08-17 22:16:15.14 Code: 0x00000000 The package execution fa... The step failed.



how to Reinstall the SQL Server 2000 tools? where to find it .

Still no solution can solve this issue .

I need a solution please .

 

[mrdenny]

Please don't cross post.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com