How to decrypt the flat file in SSIS

Question

Post reply

How to decrypt the flat file in SSIS

SriSudha

Mr or Mrs. 500

Points: 555
More actions
May 18, 2012 at 8:11 am

#261169

Hi,
My flat file source was encrypted .Now i want to decrypt then load into destination.How can i do it in SSIS ?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

With as little information provided, not sure. When and how was it encrypted? What tool was used to encrypt the file?

SriSudha Mr or Mrs. 500 Points: 555 More actions · Answer 2

Hi,

This one asked in my one of the interview only.Please help me

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Not enough info to really help. You might use the Script Task, but without more info, just a guess. If it is an interview, you should ask for more info so you can actually answer the question.

sunil.mvs Ten Centuries Points: 1031 More actions · Answer 4

To encrypt there would be logic that is defined by user

For example: 1234 Coded as 2345 (adding 1 to each digit)

1234 coded as 4321(reversing digits)

Incase delimiters like |,",: are encrypted as %,? then decoding should be done with script task as there is no component provided by microsoft to handle this in ssis

Incase , column values are encrypted(provided delimiters are not encrypted) then , logic can be handled in script component

I don't know what is the intention of question or expecting answer..

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

I would say that the purpose of the question was to see how you would approach the problem to develop a solution.