You were right

I gave the service account db_datareader and db_datawriter on the database level and the package worked fine.

I guess when the SSIS error message says an object is missing;...

Per our CISO we have to set the protection level to EncryptAllWithPassword

We are using SSIS packages just to move data from one table to another and it contains meter reading...

So the user who is calling the job in SQL server agent only has the Public role on the database / table.

I cant give him db_owner so let me give...

Live and learn

I found it so thats where it was hiding

Do the projects and packages have to have passwords set before you can deploy them on the SSIS catalog and...

Hi Phil

Sorry for the delay i created a new project and made a new package and surprisingly that the security section is missing.

please see the attachment. What can cause this?

Kal

I’ll send a snapshot in a couple of hours.

I even tried to create a new project and even the control flow properties didn’t show the protection level.

strange?????

Kal

Hi Phil

The whole project was given to me but when I click on properties for any of the packages the security section is missing completely.

It’s there when I check the...

Ok I thought so.

I have a 2016 server and had CU 14 and then I applied the GDR without CU 15 and it worked but I don’t know what problems...

Dear Steven

Are you sure if I have a GDR it will include the previous CUs?

I have to patch SQL server 2016 with CU14 with GDR. Per the instructions I need...

Dear Johan

Does it include the security patches (GDR) also?

this was the whole exercise applying a CU and a GDR.

regards

kal

Dear Johan

I can run single patches no problem but when I include more than one patch and insert the option:

/UPDATESOURCE

This is when it doesn't work

regards

Kal

Hi Fred

That didn't work even with lower case and upper case

The error is attached

regards

Kal

FANTASTIC

That was the missing link!!

You're the best DesNorton and thanks to everyone who helped.

Have a good week and a great year

Kal

Dear Gvoshol

It is giving me all employees including the ones I specified in the IN CLAUSE

So what could be wrong?

Thanks everyone for the help

Kal

@desnorton

I modified the query and joined with the employee table but as you can see from my query I need it to compare to specific employee IDs but...