QuerySimon - All Comments

re: Using the Bing API to geocode data in SSIS

Simon Lidberg — Wed, 24 Apr 2013 08:13:20 GMT

KP what you need to do is to remove the files from C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents and restart SQL Data Tools, then you can add it again and then create a new package. The following post explains what is happening

social.msdn.microsoft.com/.../E02EF3B0-7A3B-4A02-966C-AEB74D8D1A5A

re: Using the Bing API to geocode data in SSIS

KP — Tue, 23 Apr 2013 16:50:59 GMT

I compiled in VS 2012 and I am using SQL 2012. When I try to use this component in my package I get an error: "The component for the metadata for "GeoCoder Task,..." could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

re: Writeback to Analysis Services cubes from Excel 2010

Simon Lidberg — Mon, 22 Apr 2013 16:25:31 GMT

Thanks Adnan,

Hope it helped.

re: Writeback to Analysis Services cubes from Excel 2010

Adnan — Mon, 22 Apr 2013 07:32:29 GMT

Great Article. Hats off

re: Installing the BI features of SharePoint 2013

Simon Lidberg — Thu, 11 Apr 2013 20:40:55 GMT

SteveOfPekin, the PowerPivot for SharePoint features are only included in Enterprise Edition and Business Intelligence Edition. The server that will run the PowerPivot app needs to have one of these versions.

re: Installing the BI features of SharePoint 2013

SteveOfPekin — Fri, 05 Apr 2013 16:13:00 GMT

Not sure if this was mentioned anywhere in your posts, but you run into issues by not installing the right versions of SQL Server 2012. I started with using the Standard version and then ran into problems when trying to do PowerPivot (it was not there). I had to use the Enterprise version in order to get this working. Also it is very confusing when your Databases that you want to use are residing on another SQL Server than the one that is attached to your SharePoint 2013 app. Which server has to have Enterprise and which does not. Microsoft has not made it very clear on separating this out.

re: Installing the BI features of SharePoint 2013

Simon Lidberg — Tue, 12 Mar 2013 17:30:48 GMT

Hi Garrett in my case everything is running on the same server. Since it is s test environment it is ok, however for production you would typically separate the services on several servers.

// Simon

re: Installing the BI features of SharePoint 2013

GarrettMcFarlane — Tue, 12 Mar 2013 16:01:53 GMT

I think for the most part I am up and running now. Quick Question as it was not so clear above. This is all running on the same server correct. SQL and SharePoint?

re: Installing the BI features of SharePoint 2013

Simon Lidberg — Wed, 27 Feb 2013 20:16:38 GMT

Hello Cruger sorry to hear about your problems hopefully they have been solved now.

//Simon

re: Installing the BI features of SharePoint 2013

Cruger — Wed, 27 Feb 2013 18:58:56 GMT

Please note that as stated above you should use the slipstreamed SQL 2012 with SP1 and not install SQL 2012 then SP1. Lets just say I had some errors.