Viewing 15 posts - 16 through 30 (of 13,399 total)
If you are prepared to take the time to provide your sample data in consumable format (ie, CREATE TABLE / INSERT ... VALUES), you might get a coded answer.
If it...
April 11, 2024 at 8:27 am
... and no-one gets excited by a fridge.
<Phil looks away, feigning agreement>
April 10, 2024 at 11:10 am
Are you able to post the query itself?
April 9, 2024 at 12:45 pm
I think that you might have to split things up, such that one of the two different versions of the T-SQL is executed, depending on SQL Server version.
If you're not...
April 9, 2024 at 8:19 am
Hello everyone,
I hope I'm in the right place here. If not, please let me know where I can post this question.
Here's my question:
With this call dtsRuntime.Package package = app.LoadPackage(Etl_package,...
April 9, 2024 at 8:14 am
I meant it merely as a diagnostic tool, not a permanent change. But taking out the dirty reads sounds like a good idea too.
April 8, 2024 at 4:53 pm
Are you using a third-party library to convert PDF to Excel? If not, how are you doing it?
April 8, 2024 at 10:47 am
Have you considered redirecting error rows to an error table, rather than simply failing the package? This could help you track down what's happening.
April 8, 2024 at 7:48 am
Thanks allot for reply @Phil , Yes its same,
Also I suspect this might be due to expired license for Kingsway Soft. I raised this concern with management.
Sounds like you've...
April 8, 2024 at 7:45 am
Is the version of SQL Server the same on the local machine and the server?
April 7, 2024 at 8:22 am
Can the column in the source table ever be null?
April 6, 2024 at 6:24 pm
DECLARE @sql VARCHAR(MAX);
SELECT @sql
= STRING_AGG (
...
April 5, 2024 at 1:48 pm
This still sounds like an ASP.NET question. Why do you think that this is a SQL Server problem?
April 3, 2024 at 9:29 am
thanks phil, do you mean all on the same single pc? That's the kind of feedback i was hoping for. That way no one instance of sql could interfere...
April 2, 2024 at 5:18 pm
Have you considered using multiple local VMs, one per project?
April 2, 2024 at 1:37 pm
Viewing 15 posts - 16 through 30 (of 13,399 total)