This can be done inline with charindex and substring or parsename - or you can create a function to parse the string elements.  To get you started.

...

I definitely recommend that you install and setup the Integration Services Catalog.  It simplifies a whole lot around deploying and running packages.  You don't need to connect to the SSIS...

If you want automated processes - you can always schedule them in SQL Server agent, or windows task scheduler using dtsexec.  But...since this is a personal workstation you can also...

The error seems pretty clear - you need to be running SSMS as an administrator.  With that said - why do you need to connect to SSIS directly?

You don't need to 'configure' anything...this article shows how to set the connection at run time: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d8644d3-3235-41dc-9e16-bbe98fceac6a/dtexecexe-set-projectparams-in-project-deployment-model?forum=sqlintegrationservices

In that example - they are executing the project by referencing the .ispac file.

SQL...

To do that you need a script external to the cluster that monitors the state of the instances - and then performs a manual failover of all instances if it...

Well - the integration services catalog provides a location to store and manage your projects, as well as the ability to schedule them using SQL Server agent.  This also gives...

Does this help?

https://www.sqlshack.com/an-overview-of-dtexec-utility-in-ssis/

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d8644d3-3235-41dc-9e16-bbe98fceac6a/dtexecexe-set-projectparams-in-project-deployment-model?forum=sqlintegrationservices

It would probably be much easier to deploy to the Integration Services Catalog - where the connections are exposed and can be modified as needed when you setup...

It isn't very clear what you are trying to accomplish...are you saying you have code in a database that references another database?  Or - you have code that uses 3-part...

You should look at your criteria further - using those functions might cause performance issues and potentially miss data if the agent job does not process for a specific time.

You...

Well - that goes without saying...as the problems...

🙂

Agreed, so let's not even get into how badly they mangled the date functions 🙂

The best I can find is that it is controlled by the service and not externally managed.

Either way, if I had this issue on my servers I would create a...

Why is there no BOMONTH to go along with EOMONTH?  Imo it's because DATEFROMPARTS already exists and BOMONTH would just be a special case of that function and therefore...