So when I open up a SQL Server Analysis Services Project in Visual Studio and it gives me the warning "Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is not set to IgnoreError." I thought to myself: "That's a good idea." I ought to do that.… Continue reading We Don’t Need No Duplication: Eliminating the Visual Studio “Do Not Ignore Duplicate Key errors” warning.
I know. While everyone else is moving on to SQL 2012 here I am upgrading a SSAS 2005 cube to SQL Server 2008 R2 Analysis Services. I can hear Garth imploring me to "Live in the now man!" So as I went about the mundane task of upgrading a cube from a really old version… Continue reading Resolving Analysis Services “The provider ‘SQLNCLI.1’ is not registered”
Here's a real quick tip after banging my head against the desk for awhile. I had a tablix in SSRS that was supposed to be hidden if there were no rows. It was working fine until, wham, it stopped working. (Oh no. I said "wham". That obviously leads me to "Wham!". I had my mom… Continue reading SSRS: A Hidden Tablix That Won’t Hide And Wham!
Ever cut and paste a mess of generated MDX from Excel? How about a coworker who doesn't know how to use the "tab" key when working in SQL Server Management Studio? I came across this no frills online MDX formatter from "Microsoft Labs" and have been using it for the last few days to clean… Continue reading Formatting MDX and DAX: Free Online Tool From Microsoft
Couldn't have said it better... RT @lanier: “80% of #datascience is infrastructure; 20% is the fun stuff—charts etc.” - @opower at #strataconf — Michael Cavaretta (@mjcavaretta) October 24, 2012
Sometimes I wonder if some of the more random scripts I post are useful to anyone but me so if this one is useful to you definitely drop a comment below! Check it out: Our team was trying to confirm what our best practice was when creating flag columns in the data warehouse. As usual… Continue reading SQL Script: Distinct Column Values Across All Tables
This article falls into the half baked posts category. Once I figured out how to compare two variables and then overwrite one with a script task in SQL Server Integration Services, I also realized I did not in fact need to perform the task. Doh! Still a useful bit of code though so I'm posting… Continue reading SSIS Compare Variables And Change One With A Script Task
Warning! This post is barely finished. I putting it up as a reminder to myself that I had a hard time finding a post explaining how to do it and I should write a post on it. "It's impossible" they said. "It can't be done!" they claimed. "You're mad (but still surprisingly handsome!)" the women… Continue reading Create A List In Your SSRS Tooltip: Not Impossible!
Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task? If your stored procedure contains a temp table you may run into the message "No column information was returned by the SQL command" (complete error message below). Although there are a number of solutions… Continue reading SSIS: No column information was returned by the SQL command