PGP Encryption in SQL 2000 DTS Package

Posted on 2007-08-07
Last Modified: 2013-11-30
I'm relatively new to SQL 2000 DTS and need to design a package that encrypts a dab-delimited file to PGP format.
I'm wondering which encryption application would work best within SQL DTS Designer, and also how that would be implemented.

Thanks in advance,
Question by:jaimeamedina
    1 Comment
    LVL 14

    Accepted Solution

    If your encryption tool is an exe, and takes command line parameters, you can run it with an execute process task.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    There are many reasons malware will stay around and continue to grow as a business.  The biggest reason is the expanding customer base.  More than 40% of people who are infected with ransomware, pay the ransom.  That makes ransomware a multi-million…
    Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now