What they are meant for: substracting and summing values.

It's hard to see without the entire SQL statement present, but the select statements return numerical values.

edit: apparently Gail can type faster...

And the award for best topic title this year goes to:

Processing Dimension fails when it sees Michael Bublé

(thanks to Gail for spotting this)

If the collation first used is accent insensitive, shouldn't the process succeed?

As it doesn't matter if the letters have accents or not...

For those who stumble upon this thread using Google, there is a more thorough discussion at the MSDN forums:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/82db8cd4-2b4c-4b4b-b810-fb214b453886

Normally 2005 packages have the 2005 behaviour and 2008 packages the 2008 behaviour, as each has it's own Integration Services service that loads the appropriate runtime and DTEXEC executable.

This is...

SQL 2005 can not run 2008 packages, so you should only be developping in BIDS 2005, or migrate to 2008.

There is no difference between 2008 and 2008R2.

I think the easiest...

nithila.sp (2/8/2012)

---

Thanks for the reply..

I have two series for Y axis value

i.Actual

ii.Goal

X-axis is month

So when i change the series property of actual all the bar will be of same

color,this...

And I learnt about truism! :w00t:

(yes dear OP, we are spamming your mailbox with useless notifications :-D)

Ian C0ckcroft (2/7/2012)

---

Create a Data Flow Task (DFT) at the Control Flow Level of your package. Next, add a Flat File Connection Manager to your package by Right-Clicking in...

Interesting read, thanks for the link.

If you want to do everything with SSIS, you could use a For Each Loop with a file system task inside.

One loop for .xls, one loop for .txt.

LIKE THAT

But I...

Business intelligence is not a single product, it is an entire field.

You first need to know what product you will focus on, for example the Microsoft BI stack using SQL...

SQL Kiwi (2/8/2012)

---

Doesn't account for NULLs.

SELECT

t2.*

FROM dbo.temp1empdtls AS t1

JOIN dbo.temp2empdtls AS t2 ON

t2.empno = t1.empno

WHERE...

Phil Parkin (2/8/2012)

---

Actually,...

I believe this will work:

SELECT temp.empno, temp.empname, temp.age

FROM

temp1empdtls major

INNER JOIN

temp2empdtls temp

ON major.empno = temp.empno

WHERE major.empname <> temp.empname OR major.age <> temp.age