SSIS via Import Wizard SQL Server 2008 R2
You could use the wizard and load the data into a temp table then process it from there.  That's probably your easiest option.  Unfortunately while I know there is a relatively easy way to do the processing I just can't remember what it is.

The other option is going to be to use BIDS and you will probably have to use a script source to construct your input.