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.

Well, apparently your dates don't have the correct format. Inspect your data at the source or in the dataflow with a data viewer. If necessary, write error rows to a...

I don't think it is directly possible. But you can however create a trigger on the table that logs the information you need.