I found this thread, because of hitting the exact same behavior. Are there any additional insights?

My package is simple and follows the outline of the package above. There are...

Declare @a int

Set @a = 1.0/2.0

Select @a

-- returns 0

Should probably be expected by everybody.

Declare @b-2 float

Set @b-2 = 1/2

Select

+1

When it's needed, it should be accompanied by...

Didn't realize this was so old. Saw the link on an article in today's newsletter and assumed it was current.

It seems like your condition using BETWEEN is incorrect and...

Okay, I'll pick up the widget...

SQL injection has been news for an awful long time (prior to 2000). Even so, I remember seeing code that used concatenation of SQL...

Perhaps its just a figure of speech, but the fixation on firing people for this seems misplaced.

Surely, coding to prevent SQL Injection is a learned skill, like many others.

If a...

Set the amnesty date in 2003 and you'd have to fire some Microsoft programmers. I was shocked to see sample code on the architecture and practices site with concatenated queries...

Easiest path is probably to switch the file connector to see a single column. Use a Script component and specify it as a transform. The code is very straightforward and...

Are the column names changing very often? If not, your best bet is probably to ignore the header row and name the columns explicitly. In other words, uncheck Column names...

I've never been in a formal pair programming environment, but over the years there have been numerous times when getting two heads on a problem just made sense. In fact,...

lbrigham (7/31/2012)

---

Thanks for input, everyone.

Thomas Abraham (7/31/2012)

---

(Bob Brown) (7/31/2012)

---

Easy question but I have to learn to read. I picked the one that it wouldn't work on not...

Favorite use for NullIf is to prevent a divide by zero:

Select Miles / Nullif( Hours, 0 ) as Speed

From SomeTable

Wasn't thrilled with the formulation of the questions, but I don't...

We've started using a 2008 R2 server with 2005 client tools. Haven't seen this error, but a couple of similar ones.

Can't use Open Table, instead must use Select.

If...

I've only used synonyms on a couple of occassions. In each case, there were rather involved procedures which accessed tables outside the database -- in one case even outside the...

Koen Verbeeck (12/22/2011)

---

Andrew Watson-478275 (12/22/2011)

---

That's the second or third R2 limits question we've had - I've now got that page on favourites, ready for the next one ;-).

I always find...