Thursday, November 13, 2008

System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.

Problem Description:
=======================================================================
SSIS package which runs a DTS package using the execute DTS2000 component.Able to run the package in the standalone server but on the cluster getting following error
Error: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. at DTS.PackageClass.Execute() at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

Resolution:
=============
Check the ODBC DSN Connection if its proper

No comments: