February 22, 2012 at 6:09 am
Hello everyone,
The developer of SSIS Package whose not available around has password protected some the SSIS Packages that we are using.
When I try to Export the Package I am prompted to enter an password as some sensitive data is encrypted. I dont know the password, how can I work around this one? How can I recover the password? What sensitive data can be lost if I export the package?
This is crucial for me. Please help.
Thanks.
February 22, 2012 at 6:11 am
imranx101 (2/22/2012)
Hello everyone,The developer of SSIS Package whose not available around has password protected some the SSIS Packages that we are using.
When I try to Export the Package I am prompted to enter an password as some sensitive data is encrypted. I dont know the password, how can I work around this one? How can I recover the password? What sensitive data can be lost if I export the package?
This is crucial for me. Please help.
Thanks.
Is this package scheduled in a job??
February 22, 2012 at 6:13 am
Yes exactly it is. The job runs overnight.
February 22, 2012 at 6:27 am
imranx101 (2/22/2012)
Yes exactly it is. The job runs overnight.
Then you can run below command & check the result:
SELECT SJ.[name],SJS.[command]
FROM msdb.dbo.sysjobs SJ INNER JOIN msdb.dbo.sysjobsteps
ON
SJ.[job_id] = SJS.[job_id]
WHERE SJ.[name]='Your Job Name Here'
check the output of command column in the result. You should get the password in the command string after the /DE parameter.
February 22, 2012 at 6:35 am
It works. Thanksss alot. You are genious. 🙂
February 22, 2012 at 6:38 am
imranx101 (2/22/2012)
It works. Thanksss alot. You are genious. 🙂
You are welcome 🙂 Its just your kindness to say that 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply