What error do you get?

My first guess is that it is a permission issue. Maybe you did something wrong when configuring the proxy. Does the sysadmin account have permissions for...

Shabba (1/24/2012)

---

Hi,

We have a 3rd party Sybase database to which we only have select access to approximately 140 Views. We would like to report against the data in these...

It's a bit messy, but check out this thread:

http://social.msdn.microsoft.com/Forums/hu-HU/sqlreportingservices/thread/c02370b5-aeda-47ec-a3a8-43b2ec1e6c26

I would go with the OLE DB connection manager, using the native client as provider.

Reason: it is a bit faster if you use the fast load option in the destination.

I've...

GSquared (1/20/2012)

---

I just delivered a "lunch-and-learn" to the devs where I work. Since we just upgraded to SQL 2008 R2, it was on new T-SQL features they might find...

Allright, back again after 3 week hiatus. I had to choose between getting more sleep or the Thread. It was not an easy choice to make 😀

(just kidding, it was...

Congrats!

Nice question, but quite easy as hash functions are deterministic by design.

Great question, thanks.

Nice question and an even better discussion 🙂

Awesome question. It was about time there was a new QotD for SSIS.

Nice question, thanks.

Woot woot easy one 😀

The leprechaun answer is not correct? :crying:

I want me...

Nice question, learned something.