For SSRS, you can move the reporting databases.

Migrate a Reporting Services Installation (Native Mode)

Upgrade a Report Server Database

Upgrading the SSAS server shouldn't be too hard as well:

Upgrade Analysis Services

bwrightdev (3/20/2015)

---

I have solved the problem after a lot more digging around...

Here is the post that actually solved it for me:

http://stackoverflow.com/questions/23523953/empty-excel-file-permissions-issue-ssis-excel-destination-buffers-large-record

It turns out that it was something related to saving...

Do you have the Visual Studio projects of the SSAS and SSRS projects?

I would try to upgrade these and then redeploy to the new server.

The OLE DB doesn't like stored procedures or dynamic SQL, because it can't determine metadata easily.

If you want to use it in SSIS 2012 and up, you need to use...

Do you create a new excel file?

Just a few days ago...

I'm not sure what you mean.

I have an OLE DB source with SQL command from variable and I can see the columns.

Maybe there's an issue with your variable?

In this 2014 topic they still refer to the page you found.

Maximum Capacity Specifications for SQL Server

I guess this means everything is still the same, they just haven't been bothered...

That's quite a topic and there's no easy answer.

SSAS and SSRS will probably be quite painless.

SSIS on the other hand might require some work. Luckily there's an upgrade wizard that...

SQLRNNR (3/19/2015)

---

Spooky deja-vu effect after...

There shouldn't be a size restriction.

Try logging almost everything, and see how many rows the data flow writes to the destination.

codykonior (3/18/2015)

---

Couldn't find a specific sub-forum.

I was reading that when applying 2008 R2 SP1 you need to run the MDS update component manually: http://sqlblog.com/blogs/mds_team/archive/2011/08/16/how-to-install-master-data-services-mds-service-pack-1-for-sql-server-2008-r2.aspx

I was curious if that package changed...

Use DATEADD(DAY,-1,GETDATE())?

I need coffee. I was wondering for a minute why I had already answered this question while I just logged on into my computer...

I...