I repeat my question: when do you see this value? During runtime or during designtime?

Your...

You should already find plenty of free videos of SQL Server BI at the MSDN website for free.

An example:

http://msdn.microsoft.com/en-us/library/dd631816(v=SQL.10).aspx

John Mitchell-245523 (3/31/2011)

---

Saurabh

You might consider installing the development tools on a client PC instead of on the server. That way, you can keep your development separate from the function...

sam 55243 (3/31/2011)

---

... the only problem i see is while inserting data to Sample table you have used 'NULL', this won't work with ISNULL expression as it is taking it...

Well look at that, the first result from a Google search with the keywords ssas process cube from stored procedure:

http://weblogs.sqlteam.com/jeffs/archive/2008/10/27/process-olap-cube-with-t-sql.aspx

There should be no problem installing both versions side by side.

Find the .exe files for both versions of BIDS (either in the sql server folders or in the visual studio...

Check the settings for FailPackageOnFailure and FailParentOnFailure.

If you want to write to several destinations while one of them may be unavailable, I think you should give each flow it's own...

What do you mean with run? Do you mean processing the cube?

Please don't crosspost. It fragments replies and wastes peoples time.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1086616-391-1.aspx

Are you using the SQLServer Destination? If yes, it could be a permission issue:

http://www.eggheadcafe.com/software/aspnet/35447434/could-not-open-global-shared-memory-to-communicate-w-performance.aspx

Try using the OLE DB Destination instead.

Where do you see the value 20110330_012059? During runtime or designtime? Is the variable that contains the filename populated?

Nice question, thanks.

Did you use the expression that I gave you? I find that hard to believe...

What is the protection level of the package?