Hello,
I have a DTS package that import AS400 data to SQL Server.
I have to transform some data.
So I have data like 20053453 that I need to transform to 2053453.
How can I remove the second character ?

Thanks for your help.

Gael

You can transform the number in a string and then use
- SUBTRING function (in the select statement for example)
- or use an ActiveX transformation script. For example, in VBscript,
something similar to
left(cstr(DTSSource("YourField")),1) &
mid(cstr(DTSSource("YourField")),3,len(cstr(DTSSou rce("YourField"))-3))

Francesco Anti

"Gael Le Mouhaer" <gael.lemouhaer (AT) linum (DOT) fr> wrote

"Francesco Anti" <fanti_ (AT) _sicosbt (DOT) it> écrivait news:OUp2s#zcFHA.3504
@TK2MSFTNGP12.phx.gbl:

It works.

Thanks