By Eric Ness
Working on the challenging projects that our clients bring to SCS, I often run across problems that I haven’t seen before, and that aren’t well documented on the Internet. These are the types of problems that can be solved quickly if you know how to work around them, but will take hours of valuable time to solve if you’re starting from scratch.
An example of this type of problem is the unexpected behavior that the SQL Server Import Wizard displays when importing data from Excel. I recently wrote on this topic, explaining a quick workaround that will save you a lot of hassle, for my personal BI blog here:Correcting Excel Data Types in the Import Wizard