Hi,

Okay...that sounds strange...something must be different on our environments then.

I copied the Help About info of my VS22 Community:

Microsoft Visual Studio Community 2022

Version 17.11.5

VisualStudio.17.Release/17.11.5+35327.3

Microsoft .NET Framework

Version 4.8.09032

Installed Version: Community

Microsoft Visual...

Hi,

I am not sure if I understand your point but...

Yes, the name of the connection manager has nothing to do with the server name inside the connection manager definition window.

I...

Hi,

Yes, but if I was to decide, I would change the functionality so that you could drag/drop the project connection to the package when it is needed. At least in...

Hi Phil,

Yes, I opened the XML's as well and saw that they are not there but in the Connection Managers window they are...

"You can rename the connection manager without adjusting...

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...

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...

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...

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...

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...?

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...

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...

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...

• This reply was modified 9 months, 2 weeks ago by  WilburSmith.

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...

Hi

Ok thanks

I have now done as follows:

• I have both package and project connections (like I wrote earlier in this thread)
• All connection strings are set via project parameters /expression

...

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...