March 21, 2008 at 12:29 pm
Hi experts,
I know there are a lot of posts about this issue, I read and tried all of them and I still cannot schedule a SSIS package (that works fine in BIDS).
I'm sure this is a security issue because if I open the package from the repository server on SSMS and I manually add the password for my two different connections it works.
Right now my package is saved with "EncryptSensitiveWithPassword" option, I'm able to create a job that calls that package, and change the command line as suggested after the /DECRIPT option but it doesn't save the value. So it won't work.
Instead if I do exactly the same thing on the repository from SSMS, and immediately runs this, it works.
My issue is that it doesn't save my changes on the command line, it doesn't matter what I do.
This is the error: Description: Failed to decrypt an encrypted XML node because...
And, if I connect to the oracle database inside a stored procedure and call the stored procedure inside the package it works. It seems an issue with ORACLE.
Can anybody help?
Thanks
March 23, 2008 at 1:02 am
You can try using a configuraion file or save the configuration in a table. This post might help you.
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm
March 23, 2008 at 8:49 pm
I've already tried both (table and file). I really think the issue is related to oracle. I read a lot of post regarding issues when a source is oracle. Thanks for your time anyway.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply