Viewing 15 posts - 301 through 315 (of 2,917 total)
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 5:34 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 4:30 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 3:37 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 3:26 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 2:49 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 15, 2024 at 2:45 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 12, 2024 at 4:26 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 12, 2024 at 2:19 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 11, 2024 at 2:47 pm
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 above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 11, 2024 at 2:41 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 11, 2024 at 2:25 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 10, 2024 at 9:31 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2024 at 10:00 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2024 at 9:36 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
April 9, 2024 at 9:29 pm
Viewing 15 posts - 301 through 315 (of 2,917 total)