For example, SSIS is perfectly suited for importing a "flat file," such as a CSV, into a relational database. Using SSIS's graphical designer, the task is straightforward, if not entirely intuitive.

NOTE: I haven't used SSIS for years. I'm rusty, so feel free to speak gently to me.I've got an Excel sheet put together by business analysts that has very de-normalized data. I need to go through ...