Connecting Excel to Sql Server Analysis Services (SSAS)

Last week we created a cube using SSAS.  Now I am going to show you how your end users will connect to it using Excel and how they can use the data in a meaningful way while using their favorite tool (Excel).

Continue reading Connecting Excel to Sql Server Analysis Services (SSAS)

SSIS: Cannot convert between unicode and non-unicode string data types during import

Here is an issue you may receive if you try to import data from an Excel spreadsheet into a Sql Server database table:

 

Error at Data Flow Task [OLE DB Destination [23]]: Columns “firstname” and “FirstName” cannot convert between unicode and non-unicode string data types.

Continue reading SSIS: Cannot convert between unicode and non-unicode string data types during import

My favorite SSMS add-in….SSMSBoost

Sql Server Management Studio is very robust and can do many things, but like any other product cannot do everything.  Luckily there are add-ins available that fill in some of the gaps.  My favorite and one I use every single day is SSMSBoost:

http://www.ssmsboost.com

Continue reading My favorite SSMS add-in….SSMSBoost