oaky I think I might have a solution for my little brainteaser

I thought first to use slowly changing dimension in ssis, which worked fine untill I started applying all...

I set it to don't savesensitive still seeing the message popup,job itself is not failing

OK,that indeed seems to work,I initially wanted to ask this question using multiple columns & then when I finished writing the post realised I overcomplicated my question,so I simplified the...

GilaMonster (5/15/2015)

---

That's not a SQL Server query. Looks more like MySQL (the limit). You'll probably get better answers on a MySQL forum as this one is dedicated to Microsoft SQL...

Txn all for your answers they have been very insightful,sorry I didn't present the data in any consumable way but its been a terrible 2 weeks.

I'd been ill for 3...

Yeah,I've done something...

OK the issue was solved

User_A default database was master

User_B had an other default database

This was the first time this issue came up,but I wasn't under the impression this person...

Kutang Pan (3/4/2015)

---

- are you getting an error message?

- did you remember to add

using System.Data.OleDb;

at the beginning?

- did you try to debug and find out...

You have FailPackageOnFailure option in the properties of your containers

The end tables will be present atm only 1 exist.

There needs to be a dynamic switching,cause estimations are about 20-30 clients who will initially use the system.

It has been resolved,apparently the reports make use of a shared dataset on which these users did not have access to.

Gazareth (2/4/2015)

---

Bear in mind you'll only be able to see your own subscriptions on that report, those created by other logins won't show.

Edit: I'm talking rubbish if you're looking in...

Yes I'm 100% sure that's the only subscription on this report

Andrew Kernodle (2/21/2014)

---

Personally, I'm working with 2,659 databases, which add up to about 700GB of data altogether.

And yes, this is a horrible, horrible design by a vendor :-D. Really,...

I just had a look at my post & I saw a mistake,instead of code="sql",...