In SQL Server releases 2005-2008 R2 there is a programmatic approach to be able to dynamically change dataflow columns and their data types in a dataflow task from the SSIS programmatic APIs, and have a Script Component still work magically (most of the...

SQL Server Analysis Services often deals with sensitive financial numbers, sales figures,  and strategic information used by businesses. Therefore it is natural to want to protect and encrypt data when is it queries to and fro from the Analysis Services...

When you want to run Synchronization to copy an Analysis Services database from one server to another, the account running the synchronization needs to be a server admin in the Analysis Services instance receiving the database.   For example, when...

If you try to install the Data Mining Add-in into Office 2013 the setup may fail with the prerequisite error. This may happen if you are using the ClickToRun install of Office, chances are you still have Office 2010 or another version side-by-side, as...

We kept getting this error when attempt to drag and drop dimensions attributes into a PivotTable in Excel 2010 “The field that you are moving cannot be placed in that PivotTable area” We were trying to use an Excel workbook to drop in dimension attributes...

In the situation where you are trying to deploy an MDS model via the package to your Master Data Services in SQL Server 2012 you can sometimes encounter failures. Sometimes it says “See exception details for more information.” and you want to get more...

In SQL Server 2012, there is a new setup feature introduced which can apply a patch to SQL Server bits before the server is even set up for the first time. You download a cumulative update patch from the hotfix link in the Kb articles, then point setup...

This common blocking symptom really can cause trouble if you get caught off guard. When you process an Analysis Services object, like FullProcess on a database or cube, near the end of processing is the phase where it needs to swap the old files out...

Every time I try to connect to my SQL Server 2012 Analysis Services, from Management Studio or SQL Profiler I kept getting this error popup and I cannot connect. "Property name was not recognized, 'APP'"   I figured it out… I ran process...

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...

[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...

If you use a Windows server to host IIS, and you installed IIS as an additional feature after Windows was already installed for a while, its likely that if you try to use the SQL Server 2008 R2 or SQL Server “Denali” Master Data Services web service it...

If you look at current activity in SQL Server 2005 or 2008 or 2008 R2, you may notice some some sessions coming from Analysis Services where last_wait_type is TRACEWRITE. For example, when you query like this: SELECT * FROM sys.dm_exec_requests; SELECT...

  To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the...

Whenever I double-click on a profiler trace *.trc file I get the error Unrecognized command line argument. All command line arguments will be ignored. ..Please run 'profiler.exe -?' to see a list of valid command line arguments. I suspect...

There are so many SQL Server feature packs, and its hard to use search and see the whole list. I tried to compile that list here, with the latest copy at the top of each section. Let me know if I missed any :-) Generally, the packs are the same set...

  The Funny Symptom This was a very strange case. Only one SSIS package would not load. All the other packages we had loaded fine. It would fail to open in BIDS, and failed when running it from the DTExec.exe command line with similar errors. The...

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...

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...

Today we got a fun one… In Visual Studio Team Foundation Server 2010, the server has a SQL Server database(s), an SQL Server Analysis Services database (cube), and several reports on top of the cube. There were two symptoms: 1. Data was not...

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...

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#...

If you try to restore an SSAS 2008 .abf backup file to an SSAS 2005 instance, you will get the error TITLE: Microsoft SQL Server Management Studio ------------------------------ The following system error occurred: The file exists. . (Microsoft...