Yeah, the question is overly complicated, and the answer is overly simple. The POWER() function is totally unneccessary, its fairly obvious from the WHERE clause that there's only going...

da-zero (6/22/2010)

---

Robert Biddle (6/22/2010)

---

I have a Script Task in SSIS 2005. I want this task to log any errors that may occur but I do not want to fail the...

Can't you just perform an "INSERT INTO <log table>" inside your catch block? That's how I typically log script errors (and script execution for that matter).

--J

I've been thinking a lot about how these sorts of things end up happening, and in both circumstances I actually created the situation that allowed it to happen.

In the former...

Well the query was 6 lines long, creating a table with 3 columns. I did have to add a COALESCE on the primary key so that it got the...

Very sorry. I typed OUTER when I meant FULL. You're right, they were both OUTER joins, but I needed data from the right table, regardless of the presence...

Well, you could add the appropriate maintenance plan task to the SSIS package directly. That's pretty modular since it only takes a few parameters, and does all the heavy...

Asynchronous actually means "independently of the main program flow". This is the exact opposite of what you think it means. Synchronous events are events that happen one after...

I do understand that to be true, but I am the exception, not the rule. I started this job several years ago with no formal education, but quite a...

Well, I'm not sure what the cause was, but my boss actually changed his tune pretty quickly. Most likely, once he realized the actual impact of his decision, he...

Rog Saber (6/18/2010)

---

SELECT RTOV_USERS.user_id,

RTOV_USERS.fname,

RTOV_USERS.lname

...

SELECT user_id...

My boss is already starting to falter a little. He said he'd speak to the CEO next week to see if something can be floated. I think he's...

My boss is both the CIO and CFO. He's the one who put the hold on increases.

--J

Yes, from my perspective almost any excuse they gave me would have come off as BS. I'm a little bias there. But I also believe i have every...