Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-02-14 : 15:13:52
|
| I would like to validate datatype using Derived Column.My data type are such as numeric(X,X),datetime,int, and varchar.How do I do this using Derived Column.Example if row does not qualify as ISNUMERIC()...throw it in ERROR table else send it to SUCCESS table.Any Idea ? |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-02-14 : 15:24:47
|
| OR is there any way of using Conditional Split to do this ? |
 |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-14 : 15:28:24
|
| http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=687658&SiteID=1 |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-02-14 : 15:40:06
|
| Can I try to CAST the column values to DT_Numeric(38,0)[Example]..and if error then dump to ERROR table else SUCCESS table?How do I put it in place on Conditional Split then....(DT_NUMERIC,38, 0) Column1 |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-15 : 12:38:53
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/10/18/SQL-Server-Filtering-Numeric-data-from-a-character-based-column.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
|
|
|
ISNUMERIC in Derived Column