Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Friday, April 22, 2016 3:21 AM
Points: 216, Visits: 4,717
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: Saturday, September 17, 2016 8:01 AM
Points: 2,834, Visits: 2,629
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