How to import Azure blob file into Sql Server 2008
Use AzCopy, the Azure Storage Explorer, or even the Azure Portal to download the file to somewhere the SQL Server can read it, then use BCP or BULK INSERT to load it.