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

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


[quoted text, click to view]