Viewing 15 posts - 16 through 30 (of 93 total)
I would argue that designing for concurrency would be a better approach because otherwise one runs out of available time sooner or later.
I agree. I am new to the company,...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
July 8, 2014 at 1:04 pm
I should have already posted my "solution". The issue was another job was running that used many of the same packages stored in the SSIS Catalog. They hit the same...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
July 8, 2014 at 12:47 pm
This was a good question, and I am sad to say that I missed it. I thought there would be an error thrown since row 16's ID was not written...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
August 7, 2013 at 12:50 pm
Wow...to think there is so much surrounding such a simple step. Thank you all for the input...I will have to play with this even more to find all the moving...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
August 6, 2013 at 4:30 pm
Koen Verbeeck (8/6/2013)
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
August 6, 2013 at 2:45 pm
Thankfully no. The one guy who knew that step was the only one in the room who knew it. All of us in the review were either Sr. or team...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
August 6, 2013 at 2:18 pm
I appreciate the advice. I lucked out (depending on how you look at it). We are going to go ahead with the conversion to 08R2, and I'll have the .dts...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
August 6, 2013 at 2:15 pm
It might be the version issue. We are running SS2k here (we get to migrate to 08 r2 soon :-D), so there may need to be some small tweaks. Let...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
July 31, 2013 at 12:36 pm
Good catch. I think I have it fixed now. I tested it across multiple months and years, and it gave correct values.
Declare @TestDate Varchar(20)
,@StartOfWeek Varchar(20)
,@EndOfWeek Varchar(20)
...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 18, 2012 at 3:04 pm
I stand in awe GSquared. That was most impressive.
I tweaked your code a touch, because it need the end of week, and the end of month went a little odd...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 18, 2012 at 2:30 pm
As a related question, if the port is set to 1433, should it be changed to prevent this? Is this typical hacker type of issues?
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 18, 2012 at 1:32 pm
As promised I'm posting results. After getting the advice from sgmunson I revisited the original table instead of looking at the Excel version (which is where that whole mess of...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 17, 2012 at 3:44 pm
I agree, and I like the idea of at least setting up the trigger. The issue that we run into is the application is built for a federal agency. All...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 14, 2012 at 12:58 pm
Great point, and it is one that I've brought up to the team. They say we'll look at that when we get the budget, but that may be months off.
For...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 14, 2012 at 11:45 am
Sorry for the delay, I was working on another project yesterday.
I've attached all the live data (I've removed all the items that can't be released to the public). This is...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 14, 2012 at 10:24 am
Viewing 15 posts - 16 through 30 (of 93 total)