Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Decrypt flat file using SSIS? Expand / Collapse
Author
Message
Posted Thursday, June 13, 2013 10:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46
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
Post #1463383
Posted Thursday, June 13, 2013 11:59 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:15 AM
Points: 79, Visits: 243
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
Post #1463396
Posted Friday, June 14, 2013 12:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46





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













Post #1463399
Posted Friday, June 14, 2013 2:45 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:56 AM
Points: 4,974, Visits: 11,663
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?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1463429
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse