SSIS: Checking for IsNumeric()

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

tmitchelar Hall of Fame Points: 3391 More actions · Answer 1

Script component

or use a derived column(note that this will not work if numbers use leading 0's):

Result = !ISNULL([Col]) && ((DT_STR,20,1252) [Col] == ((DT_STR,20,1252) (DT_I4) [Col] )) ? (DT_I4) [Col] : 0

or

!isnull((DT_I4) [col])

All solutions taken from this link:

I prefer the script component method myself. I'm don't know VB, but it's simple enough code to understand and apply.

sql_learner29 SSCrazy Eights Points: 9107 More actions · Answer 2

Thanks

[font="Comic Sans MS"]
---------------------------------------------------

Thanks [/font]

lijnenjoost Right there with Babe Points: 767 More actions · Answer 3

Here are some alternatives

Sid:) SSC-Addicted Points: 412 More actions · Answer 4

Check below solution. No need to write extra lengthy code.

Cookies on SQLServerCentral