The question on itself is OK, but why a question about a deprecated SQL Server 2000 system table? (as BOL clearly states here)

I would have prefered the same question but...

payalvyas11 (11/30/2010)

---

I too answered incorrectly after reading the documentation of msdn. The statment "any object that can appear in a FROM clause, except synonym objects", made me assume that user...

Thanks for the link!

Nice question, thanks.

Great question, thanks.

Yes, you see an execution plan that says you are executing a stored procedure.

But...

CirquedeSQLeil (11/26/2010)

---

da-zero (11/26/2010)

---

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build them...

No problem. I'm glad it all worked out.

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build them back up"...

Sharath has explained the most important things.

If you wish to keep your connections with a password, you should try using the "Rely on Server Storage for Encryption" when your package...

I was going to ask you guys with the deal is with the Celko character, because I don't really know him. (Well, I've read an article or two from him...

First you should check if all permissions are set up correctly.

Second I'd dump the mapped drive (does it exist on the server) and use a real UNC path.

Well, they certainly need a BI solution 🙂

They have already made a good step by recognizing they are in Excel-Hell.

If I were you, I'd build a data warehouse. Data warehouses...

DontSaveSensitive is OK if you use Windows Authentication on your connections.

How is your package constructed? What sort of connections do you use? Are there passwords needed?

edit: oh yeah, what is...

Great question! You've got me thinking for a while. Definately learned something.