Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

separate numericstring values in ssis Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 10:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:58 AM
Points: 204, Visits: 4,482
Hi friends i have small doubt in ssis package .how to solve issue

flat file source data contains like
id , name

1243abcde, ravi
15896655djk , hari
9dhajkvekjkddk,kali
011galidvadidevi,lalai
based 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 ,lalai
i 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 package
Post #1422395
Posted Thursday, February 21, 2013 8:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:41 AM
Points: 2,818, Visits: 2,552
I think your best choice is probably a script task. This link might help.

http://microsoft-ssis.blogspot.com/2011/04/isnumeric-or-isnumber-expression-is.html
Post #1422635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse