November 6, 2013 at 6:37 am
Hi,
Client had provided a text file and he want us to export into sql database.But when i open the flat file it is in encrypted format and am not able to see any data on it.
Is it possible to Import the encrypted text file to sql server 2008 database.?
Kindly suggest me....
advance thanks..
November 6, 2013 at 6:47 am
No, if the file is encrypted, you either need an unencrypted version of the file, or the keys used to encrypt it so you can decrypt it. Either way, SQL Server cannot natively import an encrypted file.
November 6, 2013 at 9:48 am
Well, you can import encrypted data. It's just data like anything else.
However, it will be encrypted inside the database as well.
If the file is encrypted (not just the data), then you won't have delimiters to separate out the various columns/rows.
November 22, 2013 at 8:02 am
you're right about importing the encrypted data, I guess rereading the original post it wasn't clear whether the file was encrypted or the data in it..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply