How to import encrypted Data into the DataBase RRS feed

  • Question

  • We have a system that imports sensitive data into the database in a clear format. The process is like this: We receive the .txt file from our Business partner and than we import it in our application through Windows Forms application that inserts the data into the Database (SQL Server 2000/2005). The file is save during the transport, but at the destination point and prior to the import is accessible to several operation officers that could do some modification of the clear text file because the import is performed manually. Is there a way to encrypt the data that is send to us by the outsourcing partner and import it into the Database in encrypted form to prevent it from tampering.

    Thanks in Advance

    Thursday, December 4, 2008 7:56 PM