Personally, I would test. If you to to your SSRS instance, can you "export" or "download" a folder? I cannot, but I'm also not on 2016 (I'm on 2012... I...

Your reports are NOT stored inside the SQL database if I remember right. It is metadata and jobs that is in the database side. So if you don't back up...

My advice - check the docs first. ALWAYS ALWAYS ALWAYS check the official docs as things MAY change between versions. Link to 2022 - https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver16

As for the sysadmin, I would...

As a different approach, any chance you could spin up SharePoint? It solves most of your problems as it allows for file storage, quick searching (no need for ElasticSearch), auditing...

My understanding is upgrading from standard to enterprise is something that can be done without issue.

Now, that being said, I would STRONGLY encourage you to do the transition on a...

My best guess is permissions or firewall. I imagine there is another log somewhere (windows event log for example) that contains more information about why it failed.

Looks like something is...

If writing your own stuff is not what you are looking to do, then the next best bet is a 3rd party tool. SSIS doesn't natively connect to NetSuite. But...

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