Hi Phil,

thank you for your response.

1. Package is deployed to SSISDB (via Visual Studio by customer), not MSDB.
2. Directly executed via SSISDB context and via Agent Job (in context of...

• This reply was modified 4 years, 3 months ago by  shp.shftr.
• This reply was modified 4 years, 3 months ago by  shp.shftr.
• This reply was modified 4 years, 3 months ago by  shp.shftr.

I do know how to check for TDE in general (could check just check "select * from sys.dm_database_encryption_keys" for that) , but my task was to check for DMK to make...

Hi Sue,
I was finally able to get it to work.

I had to add the SPNs from the target instance as delegation services to the service account...

Hey Sue,

thanks for your answer:

Kerberos problems can be due to many different issues.
Did you check for duplicate SPNs?
> Yes, I double-checked that,...

Hello, thanks for the input! 🙂
I simplified the whole code to work with a single select which is a lot easier for me to see trough:

USE...

Hello Henrico,

first of all: thank you very much for the help and the quick response!

Unfortunately the script doesn't seem to work. I've tested it on a...