Viewing 15 posts - 1,891 through 1,905 (of 13,855 total)
Before I HF'd Prod today, there had been no SSIS deployments since June 9th.
(If you'll pardon the expression) I played around with the package quite a bit, as I was...
August 23, 2021 at 4:28 pm
Phil, by chance does the package use checkpoints? I've seen some odd behavior like this when checkpoints were enabled and the required checkpoint file was moved or deleted.
Hi Tim...
August 22, 2021 at 2:26 pm
I have managed to resolve this issue (it was keeping me up at night!)
I can hardly believe the solution and do not understand why it works, but it does. It...
August 22, 2021 at 11:55 am
What is the error message you receive?
August 20, 2021 at 3:22 pm
I assume you replace any functions where CASE can be used - or is it only IIF that you don't use?
Like a COALESCE with 10 arguments, for example. Why...
August 18, 2021 at 3:30 pm
CLR functions for performing Regular Expression searches aren't SQL either, but they're useful. Where do you draw the line?
IIF is part of T-SQL and is more succinct than CASE, and...
August 18, 2021 at 2:45 pm
Yes, I did analyze the execution log, the slowess happened on each route processed for each stop location.
That sounds like your entire process.
Doesn't your SSIS package contain multiple steps?...
August 17, 2021 at 7:29 pm
If you look at the original post, he checks for month less than 4.
Indeed, but there is no ELSE in there, so we have to make assumptions about what...
August 17, 2021 at 6:53 pm
all this web service is to process each route one by one for stops and students, and street corners. After one route, process another one. It repeats same process...
August 17, 2021 at 6:44 pm
Would agree - except the solution doesn't work for dates where month is greater than 4
I read the requirement several times and ended up shrugging my shoulders and sending in...
August 17, 2021 at 6:43 pm
Have you analysed execution logs to determine where the slowness occurs?
August 17, 2021 at 5:44 pm
If you are hoping for a coded solution, please take the time to provide your sample data in a form which we can paste into SSMS and execute.
August 17, 2021 at 4:48 pm
If I was going to try a re-write, do you have any suggestions?
THx.
Frederico provided some.
August 17, 2021 at 1:31 pm
String Concat missing, ur trying to concat a string and an integer
DECLARE @frdate date = '01-01-2021'DECLARE
@ytdfrDate date
if Month(@frDate) < 4begin
SET @ytdfrDate = '01/04/' + cast(dateadd(y,-1,@frdate)...
August 17, 2021 at 8:03 am
Can you provide some consumable data, please? That is, some CREATE TABLE and INSERT statements which we can paste into SSMS and execute?
Also, please explain the link between Invoice and...
August 17, 2021 at 7:56 am
Viewing 15 posts - 1,891 through 1,905 (of 13,855 total)