I agree. I am new to the company,...

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...

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...

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...

Koen Verbeeck (8/6/2013)

---

You should try to follow the question of the day here at SSC (if you don't already). Sometimes there's a great question which introduces you to little gems...

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...

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...

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...

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)

...

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...

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?

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...

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...

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...

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...