Take a look here.

Use the dropdown version selector to do the comparison for yourself.

giszzmo (5/18/2015)

---

Hello,

I have a database of students' grades, however some are numeric and some are alpha. Depending on the grade type will determine which average and which standard deviation to...

I am no mySQL developer, so please excuse me if this is really obvious, but I did a quick search and found this. Maybe the section marked 'The semi-colon outside...

Why not cut your losses? Create two ExecuteSQL tasks and run one after the other.

And here it is again for those who would prefer to see the query formatted:

select @QTY_cost = (select round(sum(QTY), 0) QTY

...

sandhuz24 (5/18/2015)

---

Greetings All

So I am in a predicament. Hopefully, experts here might be able to solve this for me.

I need to move data for some specific tables from Server1 to...

Calling someone boring just because they can't script is a bit harsh!

And the answer to (A) is that there will be no issues installing it on the same server.

Though if it's a production SQL server, you would normally not install...

Grant Fritchey (5/15/2015)

---

Vyper426 (5/14/2015)

---

I Really appreciate everyone who contributed information. I must also apologize for neglecting to let everyone know the other issue that brings me such joy in this...

Local instantaneous? That's fast!

metroman17 (5/14/2015)

---

I am trying to get the servername into a sql table.

Sql:select @@servername as ServerName as SQL command.

The above sql is part of OLE DB Source

The OLE DB Destination has...

An interesting read, thank you very much. Hope you don't mind me mentioning a few minor typos:

'FacTransaction_ColumnStore' – needs an extra 't'

'Compression ration' – ratio

'foorprint' – footprint

'datawarhouse' – missing 'e'

'which...

tom.w.brannon (5/13/2015)

---

Yes, intersect is not normal to me either. I actually changed it where exists and then used except. Still non-obvious logic for me so I am glad...

The proposed data structure is not pleasant, from a relational standpoint. You should never have repeated occurrences of people's names, for example. And rows 3 and 4 of your desired...

RantaSanta (5/13/2015)

---

Tried the steps , its still failing with same error . I have tried with one package out of five package . Driving me nuts . I can open...