Hi

We are moving a source field to a destination field. We are then moving the length of the SAME source field to another destination field, but it is blank. If we swap the two moves over, whatever is the second line is empty

Can you only use a source field once ? Is this a know bug or are we doing something dumb ?

Lou & Suzie,

How are you moving the field, via Transform Data Task/Copy Column or some
other way?

Raymond Lewallen

"Lou & Suzie" <anonymous (AT) discussions (DOT) microsoft.com> wrote

blank. If we swap the two moves over, whatever is the second line is empty.

Nope you can use the same Source field twice (>1)

How are you using the source?

How are you asking for the length?

Are you doing

SELECT col1, Len(Col1) as LengthOfCol FROM table

or are you using a Script transform?

What is the source/destination?

--
--

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


"Lou & Suzie" <anonymous (AT) discussions (DOT) microsoft.com> wrote

blank. If we swap the two moves over, whatever is the second line is empty.