We haev a DTS package that this week has decided to fail
with this error -
Step Error Source: Microsoft Data Transformation Services
(DTS) Package
Step Error Description:The task reported failure on
execution. (Microsoft OLE DB Provider for SQL Server
(80040e57): The statement has been terminated.) (Microsoft
OLE DB Provider for SQL Server (80040e57): String or
binary data would be truncated.)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Only problem is, we can't find any truncation happening !
or any bad data, or any error at all really !

The package calls a stored procedure that runs several
other procedures, that all write to a progress log table,
and when the package fails, it appears that every log
message has been produced indicating success on every step.
I tried a profiler trace and got success all the way
through, and then the package fails.

Its got me confused !

The error would suggest you are trying to squeeze a string into a character
field that is not sized accordingley.

Try this

USE TempDb

GO

declare @s varchar(50)

set @s = 'DTS is the best ETL tool on the market'

CREATE TABLE HoldMyString(col1 varchar(20))

INSERT HoldMyString VALUES(@s)

GO

DROP TABLE HoldMyString

--Result

Msg 8152, Level 16, State 9, Line 6

String or binary data would be truncated.

The statement has been terminated.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jim Trowbridge" <jtrowbridge (AT) adelaidebank (DOT) com.au> wrote