david.wright-948385 (5/15/2014)

---

Koen Verbeeck (5/15/2014)

---

I was stating two view points: on one hand, it is pretty impossible to get complex software - such as SQL Server - completely bug free. On...

david.wright-948385 (5/15/2014)

---

Your argument seems to suggest that all database products should meet the same rigorous standards, where I think the vendor should be able to sell more cheaply for a...

Grant Fritchey (5/15/2014)

---

Koen Verbeeck (5/15/2014)

---

What do you mean with this?

The table becomes read-only, so you can access...

kingdonshel (5/15/2014)

---

You are absolutely right IndextoCategoryQuota is in a Group Variable Scope, and is for a matrix header row you can find the example at this location.

http://technet.microsoft.com/en-us/library/ff487482(v=sql.105).aspx

Its a...

david.wright-948385 (5/15/2014)

---

Software and IT operations for the banking sector are already regulated, and rightly so. So too is software for military and health purposes. But it isn't reasonable to impose...

Gary Varga (5/15/2014)

---

I think that part of the reason is that we are not regulated so there is nothing to comply with. The other reason is that because we deal...

spaghettidba (5/15/2014)

---

I...

Yadava Shettigar (5/15/2014)

---

Check whether job owner has access permission to database

Check proxy account

Check 32 bit run option

Check connection configuration is supplied via package configuration or manually passed via...

ndiro (5/15/2014)

---

Probably CategoryQuota is a Multivalue Parameter. It's an array, so, the expression get a specific value in this Array.

You can define Variables for different scope. I think that IndextoCategoryQuota...

ronan.healy (5/14/2014)

---

i can get this to work as all the string lenghts a re different

tried this as well still wont work

SUBSTRING(Group,1,LEN(Group) - FINDSTRING(REVERSE(Group),"-",1) - 1)

is there anything else than...

What's the difference?

jjkool (5/14/2014)

---

I am trying to pivot the table to sql server 2008 R2.

source excel file is like this.

date 1/1/2000 2/1/2000

money ...

What do you mean with this?

The table becomes read-only, so you can access it only through SELECT...

Nice question, but I choose the wrong trace flag 🙁

Did you refresh the metadata of the data flow?