Viewing 15 posts - 571 through 585 (of 5,109 total)
Personally, I would use Powershell to do this, which can be put directly into an Agent Task; thus no need for SSIS
No one mentioned SSIS apart from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 2:32 pm
Personally, I would use Powershell to do this, which can be put directly into an Agent Task; thus no need for SSIS:
$SourceDirectory = "C:\temp"
$DestinationDirectory = "C:\YourDirectory\SubDirectory"
$File =...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 2:22 pm
Attached is a screen grab of the whole flow and a screen shot of the task that creates the table
That doesn't show us a lot; we need to see...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 11:51 am
why has the table been created with '_A2488A8ACD43465D9A357D33A3478440 ' appended to the table name
It wouldn't be; not natively anyway. To me, this suggests you have some DDL triggers, that's changing...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 10:28 am
OK, yes, it was the order of the processing being different when EXEC was used and the SQL inside the SQL was being run. When the SQL was run, any...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 7, 2020 at 9:21 am
upgrade quickly, then you can use querystore and plan guides
Upgrade (to 2019) is on the cards, but probably not till Q3 this year. Me working out the budget has...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 5:08 pm
Ok, that looks like I might be onto something. The SP has loads of scans, however, the SQL being run is all seeks. I jsut got the Actual Execution Plan...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 4:45 pm
I haven't reviewed them yet, but did wonder if, perhaps, the order in which the data engine is running the joins is different when I run the SQL and when...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 4:40 pm
Can we assume that you have a QA/Test environment which is intended to be a close-to exact copy of Prod? If so, does the problem happen there too?
If not,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 4:17 pm
Maybe you should have written: "If you were to run EXEC dbo.NoRepro in my environment ..." 🙂
dbo.NoRepor won't even do it in my environment though >_< It's literally only...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 2:39 pm
is ti sql 2019? we've seen a few issues with functions not behaving as expected - not honouring order by... is it possible that this is another sql 2019...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 2:11 pm
If you were to run EXEC dbo.NoRepro;, then you would get the errors above. If, however, you ran the SQL inside the SP, then it would succeed.
No errors for me:
Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 2:09 pm
Hi Mike,
That isn't how DATEFROMPARTS works. It's DATEFROMPARTS(<year>,<month>,<day>) regardless of the language. The block you quote is me describing when they error usually occurs; but that could never happen with...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 1:09 pm
Thom
Are you sure you don't have any five-figure years? That would explain the DATEFROMPARTS and CONVERT failures, although not why TRY_CONVERT returned no NULLs.
The constraint stops values that large...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 6, 2020 at 11:43 am
Tonight, I'll be having haggis. Pray for me.
Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In Edinburgh...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 31, 2020 at 9:47 am
Viewing 15 posts - 571 through 585 (of 5,109 total)