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
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: Sunday, November 22, 2015 7:02 PM
Points: 213, Visits: 4,673
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
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 ssis package
Post #1422395
Posted Thursday, February 21, 2013 8:37 AM


Group: General Forum Members
Last Login: Monday, November 16, 2015 7:11 AM
Points: 2,829, Visits: 2,607
I think your best choice is probably a script task. This link might help.
Post #1422635
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse