Is there a way to easily do a middle of the string (substring) on a
transformation? A copyColumn does the whole table with no changes. I
am not sure how to use middle of the string type. It seems to be only
used for one column or all the fields get the same changes.

I am having a problem with one field in some of my pages and if I can
limit the size of data it reads to something like 900 characters, this
might solve the problem.

Thanks,

Tom.

Not exactly sure what you wnt but most SQL dialects have a SUBSTRING()
function which will do this for you in the SourceSQLStatement thereby
negating any trickery in the Transforms.

It sounds as though you are maybe using the 2000 "Middle of String"
transform.

This works in exactly the same way (in fact extended) as a SUBSTRING.

It only applies to the attribute(s) to which it is applied.

You could also achieve this using an ActiveX transform but that would be
much slower.




--
--

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


"Thomas Scheiderich" <tfs (AT) deltanet (DOT) com> wrote