DTS Guru question....The statement has been terminated... DTS Package failed

Question

DTS Guru question....The statement has been terminated... DTS Package failed

Brandon_Green

SSC Eights!

Points: 948
More actions
April 14, 2004 at 10:29 am

#82655

SQL 2000> Server 2003
Single DTS Local Package
2 SQL Tasks and one Microsoft OLE DB Provider for SQL Server
Step 1 fails, step 2 completes just fine. Step 1 by itself fails...
Good luck...I hope this isn't an easy fix...my head hurts from banging it against my desk.
The following is from event viewer

The execution of the following DTS Package failed:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Descriptionackage failed because Step 'DTSStep_DTSExecuteSQLTask_1' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700

Package Name: ResultsUpdate
Package Description: Update Instron EMF and HF data to dbo_results table
Package ID: {7BE4E7A4-87AE-4FB0-B330-6F4DACAAF0ED}
Package Version: {95E80483-1279-4DD2-ADF1-21B31C189BB9}
Package Execution Lineage: {7EA01B06-D10B-4593-8272-FA1CBCFEB187}
Executed On: SQL01
Executed By: administrator
Execution Started: 4/14/2004 9:16:12 AM
Execution Completed: 4/14/2004 9:16:24 AM
Total Execution Time: 12.282 seconds
Package Steps execution information:

Step 'DTSStep_DTSExecuteSQLTask_1' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:The statement has been terminated. (Microsoft OLE DB Provider for SQL Server (80040e57): String or binary data would be truncated.) (Microsoft OLE DB Provider for SQL Server (0): Changed database context to 'Aerocellquality1'.)
Step Error code: 80040E57
Step Error Help File:
Step Error Help Context ID:0

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Looks like you are trying to update (or insert) a record that is too long for the value specified in the column definition, ie. inserting a 10 character word into a varchar(8) column.

"String or binary data would be truncated" is what you need to look at here. What does step 1 do? If it executes a proc or does an insert try doing it manually and check the origin data source for potential problems.

Shamless self promotion - read my blog http://sirsql.net

Brandon_Green SSC Eights! Points: 948 More actions · Answer 2

Yep you where right. Somebody entered the wrong information via our "Partner" quailty software.