InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:04:45 GMT20http://www.sqlservercentral.com/Forums/Topic1422395-147-1.aspxI think your best choice is probably a script task. This link might help.[url]http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html[/url]Thu, 21 Feb 2013 08:37:33 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1422395-147-1.aspxHi friends i have small doubt in ssis package .how to solve issueflat file source data contains like id , name 1243abcde, ravi 15896655djk , hari 9dhajkvekjkddk,kali 011galidvadidevi,lalaibased on this source data . i want load id columns data to load only numerics data in destinationat table output like id , name 1234 ,ravi 15896655 ,hari 9 ,kali 011 ,lalaii have an idea useing derived columns transformatoin write expresion substring and findstring.but i cannot write exactely expression.plese tell me the condition expression.in ssis packageWed, 20 Feb 2013 22:10:57 GMTasranantha