147 How to do PGP encryption and decryption using ssis

[@Quoteswave2]

How to pass the key while pulling ssis from job?

[@neerajbohara6891]

i have a excel in that there is a date column which contain two date format in that single date column (dd/mm/yyyy and dd-mm-yyyy ) And when i make SSIS package for this then it read only one date format and write all NULL for other one format. in result i get null values for dd-mm-yyyy and get correct values for dd/mm/yyyy. please respond fast and resolve this problem as soon as possile.

[@learnssis]

Take a look at this video, and use C# to import the file into sql server table, once data is imported, you can write an update query to fix the date at sql server table level. kzbin.info/www/bejne/sIKWpKyLqKatj7s

[@neerajbohara6891]

@@learnssis but i can't change anything in original excel file and while importing in sql server gets same problem, getting null values in the place of dd-mm-yyyy format and getting correct values for dd/mm/yyyy format. i given the below how column looks like with input and output in ssis package. Date input | output Date dd/mm/yyyy column | column dd/mm/yyyy dd/mm/yyyy dd/mm/yyyy dd/mm/yyyy | dd/mm/yyyy dd/mm/yyyy | dd/mm/yyyy dd/mm/yyyy | dd/mm/yyyy dd/mm/yyyy | dd/mm/yyyy dd-mm-yyyy | Null dd-mm-yyyy | Null dd-mm-yyyy | Null dd-mm-yyyy | Null dd-mm-yyyy | Null Please Provide solution in SSIS

[@learnssis]

@@neerajbohara6891Take a look at this video and see if setting IMEX=1 works for your excel file kzbin.info/www/bejne/n2XddmyvhZeaqKM

[@neerajbohara6891]

@@learnssis i already tried setting IMEX=1 but got same result. it scan only first 8 rows but i'm getting null value after 13 rows.

[@learnssis]

@@neerajbohara6891then we need to use C# for importing it.

[@lindamariapaulson343]

Can you show how to run this decryption package from SQL server agent?

[@learnssis]

You can see the steps here, like how to run the ssis package from ssis catalog. kzbin.info/www/bejne/p6O5Y3mYhtWIaas

[@simmi641]

In ssis ,there's a open pgp task of cozyroc you can explain with that as well please

[@learnssis]

I found this video for pgp task from Cozyroc for encryption and decryption. kzbin.info/www/bejne/e5Slgp15ntWDaMk

[@simmi641]

@@learnssis thank you

[@saikiran-sq8zz]

is the extension .gpg and .pgp are both same encryption?

[@learnssis]

PGP stand for Pretty Good Privacy. GPG stands for GNU privacy Guard. Both of these programs are used to encrypt and decrypt data, messages, and emails. The difference between the two is that GPG is open-sourced where PGP is not.

[@saikiran-sq8zz]

@@learnssis Thank you, I have dropped an email could you please check and reply.