I'm trying to create a DTS package dynamically with T-SQL.
The package loads an ASCII file (DTSFlatfile) into SQL.
I can get the package created, but when I execute it, the package
fails.
The following is in the error log for all columns :

Microsoft Data Transformation Services (DTS) Data Pump (0):
TransformCopy 'CopyAllColumns' validation error:
AllowStringTruncation not specified but possible for column pair 15
(source column 'COLUMN_NAME1' (DBTYPE_STR), destination column
'COLUMN_NAME1' (DBTYPE-STR)).)

I cannot find anything about a property called
"AllowStringTruncation".
Any clues how I can set this value in code.

I can get the package to run by editting it with the DTS designer.
I drop the CopyAllColumns transformation, click new, select
CopyColumn, then OK. Then it runs fine.

I believe you are looking to the DTSTransformFlags property of the
Transformation Object

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
prog.chm::/dtspproptz_32pl.htm
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
prog.chm::/dtspconst_6m5v.htm



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Randy Lane" <rmathuln (AT) pacbell (DOT) net> wrote