Hello, i have a question. In my Derived Column i would like use ISNUMERIC but this function is unfortunely not possible to use. Which alternative is used in SSIS ??? Best regards

Try this http://www.bidn.com/blogs/dustinryan/ssis/915/check-isnumeric-with-derived-column-transform-in-ssis-package Thanks Aamirhttp://sqlage.blogspot.com/

Hello, i found this website, but i didnet understand it. If i copy and paste this row (DT_I4)CheckForNumeric == (DT_I4)CheckForNumeric ? 1 : 0 and replace checkfornumeric with my attribut nothing happen... please explain me what i should write in derived column task. my attribute name is nameNB

There isn't a standard method for that. See/vote: https://connect.microsoft.com/SQLServer/feedback/details/658361/isnumeric-expression-for-ssis But here are a few workarounds: http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

hello, i hate script components, give it no other possibility ???

hello, i hate script components, give it no other possibility ??? Well read on.... solution B doesn't use Script Component: !ISNULL((DT_I8)myValueToCheck) Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

I use the following trick in the derived column transform (with <add as new column>) and no script: (DT_I4)CheckForNumeric == (DT_I4)CheckForNumeric ? 1 : 0 I found the blog post where I found that: http://www.bidn.com/blogs/dustinryan/ssis/915/check-isnumeric-with-derived-column-transform-in-ssis-packageArthur My Blog

Hello, i found this website, but i didnet understand it. If i copy and paste this row (DT_I4)CheckForNumeric == (DT_I4)CheckForNumeric ? 1 : 0 and replace checkfornumeric with my attribut nothing happen... please explain me what i should write in derived column task. my attribute name is nameNB Did you goto the advance editor and change change the error settings to Ignore Failure? If yes what will happen if the column will be alphanumeric? The above expression will cause error but since you have set ignore failure to true tis wil be ignored and in the output you will get NULL. If its numeric the condition will be satisfied and the output will be 1. Note you will never get output as 0, just 1 or NULL.My Blog | Ask Me | SSIS Basics

Hello, i found this website, but i didnet understand it. If i copy and paste this row (DT_I4)CheckForNumeric == (DT_I4)CheckForNumeric ? 1 : 0 and replace checkfornumeric with my attribut nothing happen... please explain me what i should write in derived column task. my attribute name is nameNB Did you goto the advance editor and change change the error settings to Ignore Failure? If yes what will happen if the column will be alphanumeric? The above expression will cause error but since you have set ignore failure to true tis wil be ignored and in the output you will get NULL. If its numeric the condition will be satisfied and the output will be 1. Note you will never get output as 0, just 1 or NULL.My Blog | Ask Me | SSIS Basics