I used the DTS wizard to create a DTS package that would use string trim to remove leading spaces in strings in a column. First I configured it to make the transformation to the same column on the same table in the same database. The DTS package appeared to hang and didn't finish after waiting for 20 minutes. I canceled the job. Then I configured the package to make the xformation and write the new column to a identical table in a different database (identical). The package appeared to finish and said that 7260 rows affected which is the correct number of rows. But when I looked at the table, there were still leading spaces in the strings, in other words the strings looked as if nothing had been done except the column was transferred with no string trim transformation

So does anybody have an idea where I went wrong?

I am assuming you used an ActiveX script to do the transformation. If so,
can you post the script?

Rand
This posting is provided "as is" with no warranties and confers no rights.

Rand

Not necessarily. In Shiloh there is a "Trim String" transformation.

--
--

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


"Rand Boyd [MSFT]" <rboyd (AT) onlinemicrosoft (DOT) com> wrote

I'm using the string trim transformation in the DTS. But Its not working as well as I would like. Unfortunately I need to update the column where the string is trimmed so that in a row the old value is replaced with the new version that has the leading white spaces trimed, I all I see available is a "copy column" which appends the string trimmed values to new rows - I want to replace them in the original rows.