August 22, 2013 at 4:25 am
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
August 22, 2013 at 4:32 am
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/
August 22, 2013 at 4:39 am
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#
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2013 at 6:18 am
I need to implement under data flow task. as i need to dynamically compare the values.
August 22, 2013 at 1:35 pm
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply