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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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