SQL Server Analysis Services (SSAS) Connection Properties
Recently I was having some issues getting a new SQL Server Analysis Services (SSAS) cube to process on a new development (dev) server. The error I kept receivin...
Excel Tip: Identifying the max length of values in a column
Sometimes files are received such as client feeds that contain values in columns that exceed the maximum number of characters allowed in the destination databas...
Adding Row Numbers Excel Sources in SSIS
Customized Reading of Excel Sources in SQL Server 2005 Integration Services
New Site
Where'd the old site go?