How to Decrypt flat file using SSIS?

  • Hi All,

    We have a flat file in the FTP Server which is in encrypted form, now we need to get those file from FTP Server and then decrypt that file.

    How can we do this?

    I have found two ways to decrypt the flat file

    1. Execute Process task

    2. Script task

    Can anyone let me know what will be the command if we use Execute Process task? or is there any other way to do this.

    Thanks,

    Swetha

  • When you are saying the flat files are in decrypted. do you mean to say the contents/data in the file is in encrypted form or just the flat files are password protected?

    If the data is in decrypted form, you have decrypt the data. What kind of encryption is setup for the flat files at your FTP server.

    Vikash Kumar Singh || www.singhvikash.in

  • The data in the file is encrypted and we need to decrypt it

    Do you know how to do it with execute process task?

    Thanks,

    Swetha

  • swetha.prachi (6/14/2013)


    The data in the file is encrypted and we need to decrypt it

    Do you know how to do it with execute process task?

    Thanks,

    Swetha

    Taking SSIS out of the equation, do you know how to decrypt the file manually? If so, how do you do it?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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