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

Fetch numeric values from string using SSIS Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 4:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 3, 2014 8:56 AM
Points: 14, Visits: 34
I need to implement below scenario in SSIS 2008
I am getting values like below.

EN 60320.V.1
EN 61000-4-1
EN 294
EN ISO 3506-1
EN 61400-25-6

Need output as

60320
61000
294
3506
61400
Post #1487159
Posted Thursday, August 22, 2013 4:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
you can write a stored procedure for this and then call that stored procedure using Execute Sql task component........


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1487162
Posted Thursday, August 22, 2013 4:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 13,605, Visits: 10,486
The easiest option would be to do this in .NET. You can use a script component for this.

Split alphabet character and number from alphanumeric string C#




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1487168
Posted Thursday, August 22, 2013 6:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, February 3, 2014 8:56 AM
Points: 14, Visits: 34
I need to implement under data flow task. as i need to dynamically compare the values.
Post #1487199
Posted Thursday, August 22, 2013 1:35 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:43 AM
Points: 13,605, Visits: 10,486
rohit.kumar.barik (8/22/2013)
I need to implement under data flow task. as i need to dynamically compare the values.


The script component is located in the data flow task.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1487492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse