My opinion - it depends. The whole point of the report part is to make sure things can be converted (if I remember right). So you can skip the report...

Is the file it is looking for local or on shared storage (network drive)?

If it is shared storage, you SHOULD be using the FQDN path to the file instead of...

If I am not mistaken, C# scripting allows you to pass more parameters to the datetime.tryparseexact() function. Needs more parameters, but that'll allow you to set the exact format for...

The username and password stored in the ODBC can be different than in the SQL Job, depending on the configuration you set up there. With ODBC connections, the configuration is...

Maybe I am a bit out to lunch here, but shouldn't your primary and secondary instances be the same name and have the same path to the system files but...

Personally, I would avoid EF for database design. Use SSMS, a Whiteboard, and a DBA (or 2). That way you won't end up with over-normalized data (I saw someone once...

I don't think it is due to the -, but I'd double check the length of the column and the string. If you are certain that the length is 50...

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...