VSTA setup and configuration troubles for SSIS 2008 and R2 installations

SSIS 2008 Uses VSTA 9.0 to edit Script Tasks and Script Task (in Control Flow) and Script Components (in Data flow tasks). VSTA stands for Visual Studio for Team Applications. It should look like this…  and when you click the “Edit Script…” button the Script editor VSTA windows opens when it works (which is most…

11

Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."

  Lots of similar errors during processing Analysis Services processing (on Adventureworks DW cube in my example) can fail with this error “OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.” In SQL OLEDB terms HY008 means DB_E_CANCELED (aka your query was cancelled purposefully by the caller) If you get lucky, you can…

11

Deploying MDS Samples in SQL Server 2012

[This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team specializing in MDS] MDS ships 3 samples model packages in SQL Server 2012 (as of Release Candidate 0 timeframe) that you can use to show MDS and play around with the features. The sample package files live under the…

9

Visual Studio 2010 solution build process give a warning about indirect dependency on the .NET Framework assembly due to SSIS references

Here’s how I saw the problem… Install SQL Server 2005. Afterwards, Install SQL Server 2008. (Integration Services or Management tools features are enough usually) Install your favorite new tool Visual Studio 2010. Create or Open a solution for your C# or VB application. The Solution properties should target the “.Net Framework 3.5” to have this…

8

Oracle Error when connecting from PowerPivot for Excel 2010 “Connection not open”

Today we got this error when using 32-bit Excel and the PowerPivot addin to connect to Oracle Express.   The full stack of the error appears when you expand the [Details >> ] button Error Message: ============================ ORA-06413: Connection not open. —————————- Failed to connect to the server. Reason: ORA-06413: Connection not open. ============================ Call…

6

Analysis Services – Orphaned SIDs cause error "No mappings between account name and security was done"

When trying to add a user to the administrators role of Analysis Services 2005 or 2008 or 2008R2   The following error occurs: "The following system error occurred: No mapping between account names and security IDs was done. .(Microsft.AnalysisServices)"   This can happen when using two common approaches 1. By right clicking on the server…

4

SSIS error when deploying from VS 2013 to SSISDB in SQL 2012

An SSIS package has been developed in SSDT-BI Microsoft Visual Studio Professional 2013 (freely available download). When we deploy the package to SSISDB in SQL Server 2012 RTM or SP1 (11.0.3153.0) and run it, it returns the following error, because the SSIS 2014 package format is not downgradable to SSIS 2012 version format.  “The package failed…

4

What is the RPC and RPC Out option on a SQL Server linked-server?

Someone asked me this week – what are the relevance of the RPC and RPC Out settings on a linked server? Do you need both of them or only one of them set to True? The documentation is online in this article, but it doesn’t clearly show examples or provide enough context, so I will try…

2