147 How to do PGP encryption and decryption using ssis
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- How to do PGP encryption and decryption using ssis
drive.google.c...
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
How to do PGP encryption and decryption using ssis
How do I encrypt and decrypt with PGP?
How to encrypt data in SSIS package?
How to use PGP encryption command line?
How do I encrypt and decrypt with gpg?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”
How to pass the key while pulling ssis from job?
Can you show how to run this decryption package from SQL server agent?
You can see the steps here, like how to run the ssis package from ssis catalog.
th-cam.com/video/qrV2FbQpU3I/w-d-xo.html
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.
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.
th-cam.com/video/zQ3syUsAzYY/w-d-xo.html
@@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
@@neerajbohara6891Take a look at this video and see if setting IMEX=1 works for your excel file
th-cam.com/video/i4zE9yP2grA/w-d-xo.html
@@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.
@@neerajbohara6891then we need to use C# for importing it.
In ssis ,there's a open pgp task of cozyroc you can explain with that as well please
I found this video for pgp task from Cozyroc for encryption and decryption.
th-cam.com/video/EcBQjCipP2g/w-d-xo.html
@@learnssis thank you
is the extension .gpg and .pgp are both same encryption?
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.
@@learnssis Thank you, I have dropped an email could you please check and reply.