Very Urgent DTS issue
-
Hi
We are facing DTS failure in our environment with the error message as follows,
Executed as user: DBSW007\SYSTEM. ...ecuting... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnError: DTSStep_DTSExecuteSQLTask_5, Error = -2147217833 (80040E57) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217833 (80040E57); Provider Error: 3621 (E25) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217833 (80040E57); Provi. The step failed.
Anyone pls advice on this
-
What's inside this DTC package? T-SQL or anything?
-
Looks like one of the tasks if failing. Can you provide details on this task? Are you sure it's configured correctly?
-
The output you provided looks like what you'd see in job history. See the DTS package log for better error messages. If you don't have logging enabled for the package, do so by opening it in DTS Designer, select Package Properties, Logging tab, check "Log package execution to SQL Server". Restart the job and check the package log after failure.
Greg
Greg
-
A quick Google on the error code seems to indicate that this is a data truncation issue. If you're able to veiw the detail messages from the DTS package log you'd be able to confirm this.
--------------------
Colt 45 - the original point and click interface
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply