I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2.
The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm of numbers. It also lacks support for normalizing data, or mapping columns into different tables. In short, I need something better.
Your recommendations?