That thought had crossed my mind, but the problem is, these reports are going to our clients. Clients took months to decide on the formatting of these reports.

So the...

Not clear what you are asking. Did you execute a package on the server and now your want to delete the the execution for that server? Or you...

Refer to the link: https://www.mssqltips.com/sqlservertip/2450/ssis-project-deployment-model-in-sql-server-2012-part-1-of-2/

MNDN doesn't really have pros and cons.

I recently upgraded my company from SSIS SQL 2008 R2 to SQL Server 2014 and we went...

I would do it on the source. It performs much better.

Alternatively, I would join schedule a job for night time which joins 15 tables, and store the data...

I would spin up two Dev Server, Standard and Enterprise. Use MSDN licenses on them. Then develop enterprise freatures on enterprise Dev and standard on standard server. It...

Looks like your Variable is data type is object. Try DT_STR and see if you get the same error.

You can display both of the values in one report but in separate grids, but they cannot be in the same grid. For example, you cannot have 5 column...

In Design View, right click on the cell you want to format, then right click "Text Box Properties". Click on "Number" tab and select the correct formatting.

Quick tip, if...

Is there a reason you want to stop the package if there is no file? If there is no file, package wouldn't do anything anyways and just complete. ...

You should have posted this under SSRS. I have an answer for you.

I did this a while ago, so I recreated the problem in AdventureWorks and took screen shots...

Good Post. But Next time, please paste the code instead of images. It helps to have the code and work thought example as reading the article.

If you are pulling the data from a Cube, then MDX. If you are pulling from SQL Database, then SQL.

If you are going to be working...

I got an answer for this from Stacia Misner:

Unfortunately once you customize the MDX, you lose the context-sensitive features in PPS such as drilldown. The only way to resolve this...

Enterprise Edition of SQL 2008 R2 is not needed to run PerformancePoint 2010. I am running PP2010 with SQL Server 2008 R2 Standard. I've already published dashboards and it...

You didn't mention type of datasource. I am assuming it's a Analysis Services cube and I will answer the rest.

1) Go into details using drop down and deselect...