Depending on what your system type is you could use
REPLACE(ProductNumber('-','') as ProductNumber
in your SourceSQLStatement
Or in an Active X transform you might use
DTSDestination("Name") = REPLACE(DTSSource("Name"),"-","")
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Craig HB" <CraigHB (AT) discussions (DOT) microsoft.com> wrote
Quote:
I am importing product data from an external system. The ProductNumber
column in the source table is in this format : 230-103, and I want to
|
convert it to number by dropping the "-".
Quote:
Does anyone know the ActiveX script that I can use in the transformation
to do this ?
Thanks,
Craig
|
Re: ActiveX script for converting column -
07-27-2004
, 02:44 PM
Linear Mode
