within a dts package I am using a single DTS.DataPumpTransformCopy for all
columns.
I am trying to turn of full data truncation by setting the
DTS.Transformation2.Flags = 63 which should include all of the possible
truncation options ( i also tried just setting this to 4 for string
truncation and 128 for ForceConvert to no avail )
regardless of the Transform2.Flags value , I always get the error :
Microsoft Data Transformation Services (DTS) Data Pump
Data for source column x ('columnName') is too large for the specified
buffer size.
on any strings that overflow the destination column width.

all of the docs state that including DTSTransformFlag_AllowStringTruncation
( 4 ) will result in string data being truncated to fit the destination
column width - it seems that this not the whole story.

can anyone tell me what i am missing here ?

gerry

Hi Gerry,

I have posted a answer to this same question in the
microsoft.public.sqlserver.programming queue. Please reply me in that one.
Thanks for you understanding.

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.