Viewing 15 posts - 241 through 255 (of 2,855 total)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
April 9, 2024 at 9:29 pm
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...
April 8, 2024 at 7:09 pm
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...
April 5, 2024 at 7:22 pm
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...
April 4, 2024 at 7:53 pm
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...
April 4, 2024 at 7:41 pm
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...
April 4, 2024 at 2:11 pm
Viewing 15 posts - 241 through 255 (of 2,855 total)