批量导入文件到SQLSERVER

DECLARE @AA AS VARCHAR(20)
DECLARE @T AS INT
declare @sqltmp varchar(1000)
 
SET @T=1
WHILE @T<= (select count (*) from tablelist)
BEGIN
begin try
  SET @AA = (SELECT TABLENAME FROM TABLELIST WHERE ID=@T)
DECLARE @SQL  VARCHAR(1000)
SELECT @SQL =
' BULK INSERT '+@AA+
     ' FROM ' + '''C:/CSV/'+
           @AA  + '.CSV''
     WITH 
    (
    FIELDTERMINATOR ='','',
    ROWTERMINATOR = ''/n'',FIRSTROW=2,
    FIRE_TRIGGERS
     )
'

  declare   @cmd   varchar   (1024)  
  SELECT   @Cmd=('master.dbo.xp_cmdshell   '+'''MOVE   C:/CSV/'+@AA+'.CSV'+'   C:/CSV/PROCESSED/'+'''')
 
SELECT @CMD
EXEC   (@Cmd)  
EXEC (@SQL)

--PRINT @SQL
 end try
 begin catch
 print @AA
 end catch
 
SET @T=@T+1
END

 

-----文件要放在服务器上