I have about 12 DTS packages inside 1 dts package and it's been running fine for about 2 weeks now and I got this error on one of the 12 dts package's this morning. I googled the error and found the below link:
But I am not using any VB code in running this DTS.
I am running this DTS as a scheduled sql job where I am using DTSRUN ...oper sys command.
Any help is greatly appreciated, thanks!!
Below is part of the error:
Event Type: Error
Event Source: DataTransformationServices
Event Category: None
Event ID: 81
Time: 11:10:11 AM
The execution of the following DTS Package failed:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Execution was canceled by user.
Error code: 80040427
\Error Help File:sqldts80.hlp
Error Help Context ID:10100