June 9, 2008 at 9:22 am
I am receiving the error shown below. It runs perfectly until it gets to some active x code which has a autoexec on an access database which runs some queries. The dts packages runs perfectly everytime when run on my machine, but when scheduled to run on server over night it fails at the active x step. We have looks if the server has access to the folder which the database is in and it all seems fine. Has anyone got any ideas which can help me?
Executed as user: LOWELL2\SQLSERVICE. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 08:00:00 Error: 2008-06-06 08:23:41.20 Code: 0x00000000 Source: Execute DTS 2000 Package 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 DTExec: The package execution returned DTSER_FAILURE (1). Started: 08:00:00 Finished: 08:23:41 Elapsed: 1420.23 seconds. The package execution failed. The step failed.
Thanks
Paul
June 9, 2008 at 9:27 am
I think this KB article from Microsoft will help:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply