conver numeric data to string data in ssis

Question

conver numeric data to string data in ssis

asranantha

SSCarpal Tunnel

Points: 4246
More actions
December 13, 2012 at 8:20 pm

#272039

The source is a relational table and the data is shown below:
Code:
value
--------
65020
78250
58264
Convert the numbers into string format and load into target using ssis.
The target data is:
Code:
sixtyfive thousand ninty
seventyeight thousand fifty
fiftyeight thousand twosixtyfour
target destination is flat file and sourc file also flat file dat. how we achive this task in ssis.plz tell me .

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

You can't. You'll need to do custom coding in .NET to achieve this, and it won't be easy. Search the net to found out if someone else has already coded something similar.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tibco29 SSChasing Mays Points: 655 More actions · Answer 2

Need clarification..what is our input and what is your out put expecting or you may send to my personal mail ..also..i will try to solve,as per what i understand

You have to take source component of input and destination component of out put

Lowell SSC Guru Points: 323504 More actions · Answer 3

there's a couple of script contributions:

there's several threads on the same subject as well.

http://www.sqlservercentral.com/search/?q=number+to+words

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!