Hi there!

Currently I have a simple query that selects a product id and combines this
with a URL, so that the result comes out as http://www.x.y/page.asp?pid=zzz
..

This is just with a simple 'copy column' DTS. But I want to expand this, and
replace certain characters with some other. I strongly believe it can be
done with an ActiveX script, but I am absolutely clueless in how to select
the 'source column', replace characters, and 'deliver' the result to the
'destination column'.

Is there a friendly soul here that can help me on the way in this (simple?)
task?

--
I doubt, therefore I might be.

If you are using SQL Server then instead of simply specifying a table as the
source you can specify a statement and use the REPLACE() function
Even if you are not using SQL Server then most Sources will have a REPLACE()
type function.

Yes you can use an ActiveX transform and the syntax would be similar to

DTSDestination("DestinationColumnName") = REPLACE(
DTSSource("SourceColumnName),...........)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Kim Noer" <kn (AT) nospam (DOT) dk> wrote