Viewing 15 posts - 871 through 885 (of 11,678 total)
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:
March 20, 2015 at 11:18 am
bwrightdev (3/20/2015)
Here is the post that actually solved it for me:
It turns out that it was something related to saving...
March 20, 2015 at 11:14 am
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.
March 19, 2015 at 2:06 pm
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...
March 19, 2015 at 12:25 pm
Do you create a new excel file?
March 19, 2015 at 10:49 am
bkubicek (3/19/2015)
It seems that this is a duplicate or a question that was asked a few years ago.
Just a few days ago...
March 19, 2015 at 8:29 am
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?
March 19, 2015 at 8:28 am
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...
March 19, 2015 at 8:24 am
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...
March 19, 2015 at 8:21 am
SQLRNNR (3/19/2015)
Koen Verbeeck (3/19/2015)
I need coffee. I was wondering for a minute why I had already answered this question while I just logged on into my computer...
Spooky deja-vu effect after...
March 19, 2015 at 7:38 am
There shouldn't be a size restriction.
Try logging almost everything, and see how many rows the data flow writes to the destination.
March 19, 2015 at 2:40 am
codykonior (3/18/2015)
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...
March 19, 2015 at 2:38 am
I need coffee. I was wondering for a minute why I had already answered this question while I just logged on into my computer...
March 19, 2015 at 2:24 am
e_dorham (3/18/2015)
From the table designer I right click the column I want to make the primary key then from the drop down menu that appears I select 'Set Primary Key'
I...
March 19, 2015 at 2:21 am
Viewing 15 posts - 871 through 885 (of 11,678 total)