Great article. I never seriously considered Amazon until now, and after looking into it I found one important fact not mentioned here. The free trial!

I imagine that there are a...

Well the stairways here are always pretty good, this one should have everything you need. http://www.sqlservercentral.com/articles/Stairway+Series/72649/

I always learn the best by doing. And for SSRS grouping, I always start by...

vanessachse81 (6/20/2012)

---

I am having a problem with my query and subquery within the query. I get and error:

Subquery returned more than 1 value. This is not permitted when the...

Thanks, thats a good article. It looks like what I'm struggling with is common. The pieces that keep throwing up road blocks for me are things like Customer Income. On...

Aww, now I can't call Microsoft and say "...but these people on SQL Server Central said YOU are wrong.." lol jk.

Thank you everyone. This seems to match everything I've managed...

FYI, I've found that this bug has been fixed at least with BIDS 2012.

I can't believe it...Rebooting the server fixed the issue. Thanks for the help, if it wasn't for that link I honestly don't know how long that would have taken me...

I'm open to it, but a little confused. This seems to be a database setting, not server setting.

Thanks for link, unfortunately after enabling "Allow inprocess", I'm unable to hit the oracle server from any account. However I did notice something that I did not do, and it...

Well, thats what I attempted to do when I created the ETL account, but it's not working. I can only hit the linked directly when logged directly into Mgmt Studio...

The AMSCRYSTAL login is one provided by the vendor for the Oracle server only, it's not a valid account in SQL server.

I noticed that my windows account worked because...

Yes to both questions, using my Windows credentials I can query the linked server straight out of mgmt studio, here is the create statement for the linked server.

/****** Object: ...

What a great book title :). To give you an idea of how far out of my element I am..I have to read this after I pass my CPA exams,...

Very enlightening. I was actually shrinking my log files in the first and last step of an ETL run LOL. We need a real DBA so badly.

I don't want to double post, but if an admin can somehow convert this thread to a poll I think that would be interesting as well.