.fmt 格式
https://msdn.microsoft.com/ja-jp/library/ms191479.aspx
BULK INSERT TMP_TableName
FROM 'D:\temp.csv'
WITH (FORMATFILE = 'D:\csvformat.fmt' ,
FIRSTROW = 0 , MAXERRORS = 100 , KEEPNULLS , BATCHSIZE = 1000 ,
TABLOCK , DATAFILETYPE = 'WIDENATIVE')
csvformat.fmt'
9.0
3
1 SQLCHAR 0 100 "\t" 2 NO ""
2 SQLCHAR 0 100 "\t" 3 NAME ""
3 SQLCHAR 0 100 "\r\n" 4 AGE ""
CREATE TABLE [dbo].[TMP_TableName](
[SeqID] [int] IDENTITY(1,1) NOT NULL,--行号自增列
[NO] [int] NOT NULL,
[NAME] [varchar](12) NULL,
[AGE] [varchar](12) NULL
) ON [PRIMARY]
GO
https://msdn.microsoft.com/ja-jp/library/ms179250.aspx
http://blog.csdn.net/jackmacro/article/details/5959321
http://rsljdkt.iteye.com/blog/1147707