August 18, 2007 at 2:06 am
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
but I can’t understand how to solve it, it says Reinstall the SQL Server 2000 tools so how to ? where to find it ? knowing that I use SQL SERVER 2005 . 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.
August 21, 2007 at 1:52 am
Do what it says - see http://support.microsoft.com/kb/919131 for more detail and links to the download for the DTS components.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply