DROP TABLE [dbo].[TestTable] GO CREATE TABLE [dbo].[TestTable]( [Num1] [smallint] NOT NULL, [Type] [char](2) NOT NULL, [Num2] [int] NOT NULL ) GO DROP EXTERNAL DATA SOURCE MyAzureBlobStorage GO CREATE EXTERNAL DATA SOURCE MyAzureBlobStorage WITH ( TYPE = BLOB_STORAGE, LOCATION = 'http://127.0.0.1:10000/devstoreaccount1/testcontainer/'); GO BULK INSERT [dbo].[TestTable] FROM 'bulktest.txt' WITH ( DATA_SOURCE = 'MyAzureBlobStorage', FORMATFILE = 'format.xml', FORMATFILE_DATA_SOURCE = 'MyAzureBlobStorage', BATCHSIZE=4000, MAXERRORS=1);