OK, that won't work in a dataflow with an OLE DB Command, as the sp can probably return more than one line. Next time be a little more specific in...

You have the protectionlevel of your package probably set to EncryptSensitiveWithUserKey, which is the default. This makes sure only you can open and execute the package without losing sensitive data.

However,...

If you know a little bit about batch programming, than the file is pretty easy to write.

Here you can find the details about the DTEXEC utility, along with it's parameters:

dtexec...

Nice question, thanks.

And while your at it, check out the new PowerView in...

The OLE DB Command just fires the stored procedure against the database.

If you do not do anything with it, the data in the dataflow stays the same. Hence the one...

Allright, I did the test.

* Created an Excel file in 2010. In the Save As window, there is no way to differentiate between 2007 and 2010, so my guess is...

Usually the business imports the results into...

GSquared (2/15/2012)

---

Koen Verbeeck (2/15/2012)

---

Brandie Tarvin (2/15/2012)

---

Since we're back on the original topic...

Why does the sky change colors?

Sometimes it's pale blue, sometimes it's dark blue, sometimes it's black with little...

I have read your question a few times, but I still have no idea what you're asking.

What tools are you using? What are you exactly trying to accomplish?

edit: fixed typo

cengland0 (2/15/2012)

---

The BOL reference also says:

I didn't...

Brandie Tarvin (2/15/2012)

---

Since we're back on the original topic...

Why does the sky change colors?

Sometimes it's pale blue, sometimes it's dark blue, sometimes it's black with little lights, and sometimes...

Joy Smith San (2/15/2012)

---

Thank you somuch....... It started working now.

Almost 3 days I was struggling with this. I hardly know Analysis Service. So I couldn't even look into the...

Joy Smith San (2/15/2012)

---

Nothing was there in security tab. I added my login there and am able to BROWSE in management studio now. Thanks a ton.

In visual studio, it...

Log in into SSAS using Management Studio. Right click on the server, select Properties and look at the security tab.