Post reply

How to decrypt the flat file in SSIS

  • 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 ?

  • May 18, 2012 at 8:24 am

    #1489716

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

  • May 18, 2012 at 8:19 pm

    #1490062

    Hi,

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

  • May 19, 2012 at 1:34 am

    #1490090

    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.

  • May 19, 2012 at 10:25 am

    #1490135

    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..

  • May 19, 2012 at 11:07 am

    #1490142

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

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

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