SSIS Derived Column Cannot check ISNUMERIC -- sql server dts

James
11/8/2006 12:53:03 PM

Hi,

I have an overloaded column from a csv file that can have two different
values. The rules are, if the column is numeric then that should be
put in the numeric column. If it is alpha-numeric, then I want to put
it into a string column.

I've tried to use the derived column transformation but it does not
have any functions to check for the type. Seems like it should.
Please help....

Thanks,
James

Arnie Rowland
11/8/2006 2:02:54 PM

Check in Books Online about using CASE...

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

sql server dts : SSIS Derived Column Cannot check ISNUMERIC