My preference is to NOT use maintenance plans unless it is the only option or required by the business for some reason. The reason being - configuration. Maintenance plans give...

Reading the error, my guess would be that you have an invalid username or password in your connection string for the SQL Anywhere driver you are using in SSIS.

I am...

Did you try any of my other suggestions like re-deploying the package?

Did you get any errors or warnings when upgrading from 2017 to 2019?

Did the service account change when you...

As a thought - did you upgrade from 2017 enterprise to 2019 standard?

If not, do you have any other logs to look at? Those logs just say that your POST...

Ah, in that case, I would imagine you would have needed some sort of VPN to connect back to your SQL instance unless it is exposed to the internet. If...

My opinion - don't. As far as I am aware, there are no official apps from Microsoft for connecting to SQL Server for iPad. ANY 3rd party app runs the...

Just wanted to point out some downsides to server hosted too. First there are licensing costs as you need to license a new OS (similar to the VM approach BUT...

My guess about it "worked previously but doesn't now" is that it is a combination of things. First, changes to the client machines (office updates, OS updates, GPO's being applied...

Just want to add that you MAY need or want to discuss with your IT dept as well. Hosting stuff locally on a "take home" machine (work laptop for example)...

Offhand, I've not tried this but my 2 cents are below:

SSIS - if you don't have the database master key, then any and all encrypted data is possibly going to...

I am 99.99999% sure that the problem is NOT in the report, but with Excel.

IF Excel sees the value as a date, it will do its best to parse it...

My first step would be to read the docs on a restore. You can change the file locations for the MDF and LDF when you restore. link -

I think the problem you are seeing is because you are sorting on the group (just guessing here). If you sort the tablix instead of the row groups, it will...

Just a thought here from reading the XML, but any chance you have a trigger on CREATE_JOB_LOG that writes to the second DB (Logs_Epass)? or I may be reading the...

One thought, which Jeff implied, on performance improvement would be to pre-calculate the data. What I mean is rather than calculating the data on demand, do a nightly (or hourly)...