I am importing numbers from a file. The numbers in the file always have the
following format:
"0,00" -> which means a comma is used as decimal separator.

During the import I multiply this number by 100. I do this using a VB
Transformation Script.

Now there is one problem with this:
As soon as SQL Server Agent is running under an account with Regional
Settings that define the "." as decimal separator I get wrong values,
because the script parses the number according to the Regional Settings.
What I need is to parse the number from the file, without taking the
Regional Settings into account.

How is this possible in VBScript?

rgds,
tom

Do a replace on the column before you multiply or simply
take away the decimal seperator before you multiply if
you know how many decimals are in the column and the
divide the number by for example 100 so you get the
decimal separator back in place.