Viewing 15 posts - 1 through 15 (of 100 total)
Hi,
Yep, it (Microsoft Connector for Oracle V1.3 ) worked but it does not when run from inside the JOB....
My friends have tried it on the...
March 18, 2024 at 12:31 pm
No that is not the case...I have copied a package or package objects within one project though but that should be a normal procedure...
I might even recreate those packages but...
March 13, 2024 at 4:16 pm
OK
I moved over to JOBs instead now.
I created credentials (me) and a Proxy 'Win_Auth_Proxy' that uses me credentials
The loads that only uses Win Auth (thatis, from STG to DW or...
March 13, 2024 at 4:05 pm
Okay thanks
I'll skip this 'Execute package' from the Catalog project then
Service account is domain account
I need to either create SSIS Proxy or then ask that they have the service domain...
March 13, 2024 at 2:55 pm
Jep ok
It says 'Caller' - I guess that is the account it runs then...
Well, the ConnectString states that the connection is Win Auth, so why the ''..ANONYMOUS LOGON' error then...?
March 13, 2024 at 2:44 pm
Hi
Like I tried to write in my earlier message, yes, several different SqlServers (and one Oracle)
With native users and Win Authentication are bot widely in use
Like said, I am connected...
March 13, 2024 at 1:39 pm
Hi
Well I did set the DelayValidation = True to all connections in VStudio an then redeployed the project - same erros
I don't seem to understand the whole credentials picture here...like...
March 13, 2024 at 12:03 pm
Hi,
I now have the TEST/PROD environments set as seen below in the picture. Connect Strings and Passwords are all (project) parametrized and then the mappings done in the SSIS Catalogs...
March 13, 2024 at 8:00 am
Hi
Now I read the stories behind the links and I understood that EncryptSensitiveWithPassword will not cause any trouble with the JOBs and also that admins can export the packages and...
March 11, 2024 at 1:22 pm
Hi
Ok thanks
I have now done as follows:
...
March 11, 2024 at 12:58 pm
Yep,
My problem too...I can not test Agent Jobs/Steps on my own. That is why I am trying to figure out as much as possible "in theory" before we hit that...
March 10, 2024 at 3:13 pm
Hi,
"1 - Setup Project Parameters - flag them as Sensitive (in SSIS Catalog EVERYTHING should be Project Parameters).
2- setup Package parameters - only for the Sensitive parameters. set these as...
March 10, 2024 at 2:17 pm
Thanks
DontSaveSensitive - If I set this, do I need to give the passwords every time I load the package to VStudio and run it?
EncryptSensitiveWithPassword - how would this show in...
March 8, 2024 at 1:01 pm
Ed,
Thanks, this 'Microsoft Connector for Oracle' worked for me fine
https://www.microsoft.com/en-us/download/details.aspx?id=105811
('ODAC 19c' also brought the Oracle OleDb choice to the the OldDB list but itdid not work for me)
Ville
February 13, 2024 at 5:33 am
Hi again,
Now I downloaded ODAC 19c from https://www.oracle.com/database/technologies/net-downloads.html
I took both 32 and 64 bit versions.
Like said, the VStudio is 64 bit. That makes me think the 64 bit...
February 9, 2024 at 1:07 pm
Viewing 15 posts - 1 through 15 (of 100 total)