I've had this happen on multiple occasions. VS and SSIS are just full of bugs. They have been since I first started using them 15 years ago. Don't waste your...

I have a Java Specialist certification, but can't say I've actually ever done any Java or remember much of it...

But yeah you're correct, you need the Java Runtime Environment to...

I zipped the Jars directory and then deleted the Jars folder. This way they are still there just not accessible. I've already done this on all our production 2019 instances...

Since I last posted the services went back into a running state on their own. Now I can't get them to show pending again. I added the service dependencies back...

Thanks for posting this article, doesn't seem it changed anything though.

These are the dependencies listed.

I added the dependencies in the registry and restarted.

I had all services stopped...

So I just noticed the services have now entered the running state. I guess I never waited long enough before rebooting again.

If anyone has anything to add I'd like to hear...

Last thing to note, this is just one possible method, there are other ways. One caveat of this method is having to loop through an entire directory that could contain...

I've also attached the package, just download and rename to something.dtsx

I'm using 2019 hopefully that works.

Attached a PDF with an example. Hope this helps.

Ok apparently PDFs are not allowed. Here's some screenshots instead.

• This reply was modified 2 years, 11 months ago by  TangoVictor.

So the issue is that you don't know the filename?

If you can loop through the directory then you can put the full path of each file in a variable (on...

Yeah this is for the BI side, wish Microsoft was as generous with these products. Thankfully CDC was added to standard.

Licensing is like some kind of twisted game Microsoft likes...

OK thanks, and for dev/test we download installs from our VS subscription (MSDN) which are free and we always install whatever version/edition we will be running in production. In this...

What I've done a few times in the past with this is to completely remove the projects from SSISDB and re-deploy and also setup a new job. The weird part...

Awesome and yeah you're welcome glad I could help.

Gotta love SSIS/VS.

Can you roll back without loosing too much?

You could create a new project and add that package into it to see if you can open it. It's hard...