Using Excel 2007 files as a Source in SSIS 2005
Thanks to “jaegd” for his post here: forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example ...
Category: Technology
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...