--Performance improver.
SET NOCOUNT ON
--Local variable declaration; dont edit anything here.
DECLARE @nSQL VARCHAR(8000)
DECLARE @DIR_COMMAND VARCHAR(1024)
DECLARE @path VARCHAR(1024)
DECLARE @Temp_Table VARCHAR(64)

-- Put the drive where your csv files are placed here
SET @path = 'C:\Users\Espen\Desktop\Intraday\Textfiles\IQ\Intraday\'  
-- DO NOT EDIT this command ; 
--this will only absorb the filenames from the above path
SET @DIR_COMMAND = 'dir  /b "' + @path + '"'

--YOUR_TABLE_NAME 
SET @Temp_Table = 'CSVTest4'

DECLARE  @FileList table(OutputList varchar(500) NULL)
INSERT INTO @FileList 
exec xp_cmdshell @DIR_COMMAND

IF (RIGHT(@Path,1) = '\')
  SET @Path = LEFT(@Path,LEN(@Path) - 1)

SET @nSQL = ''
SELECT @nSQL = @nSQL + 
       N' BULK INSERT ' + CAST(@Temp_Table AS nvarchar(100))
     + N' FROM ''' + CAST(CASE WHEN CHARINDEX('\',OutputList) = 0
                               THEN @Path + '\' + OutputList
                               ELSE OutputList
                          END as nvarchar(255)) + N''''
     +N' WITH (FIELDTERMINATOR = '','')' + CHAR(10)
FROM @FileList
WHERE OutputList IS NOT NULL

PRINT  @nSQL
-- Comment the above PRINT statment and uncomment the following 
--EXEC statment to execute the task
--EXEC  (@nSQL)  

for %a in (c:\Users\Espen\Desktop\Intraday\Textfiles\IQ\Intraday\*.csv) do bcp testminidatabase..CSVTest4 in %a -T -Smyserver -c

quote:

---

Originally posted by lordoftrades

Ok, I've read about it, don't know how it works though. But I thought it was left out from the SQL Express version?

Kind regards
Espen

---

quote:

---

Originally posted by xhostx

quote:

---

Originally posted by lordoftrades

Ok, I've read about it, don't know how it works though. But I thought it was left out from the SQL Express version?

Kind regards
Espen

---

Yes, that's correct.

--------------------------
Joins are what RDBMS's do for a living

---

EXEC master..xp_cmdshell 'for %a in (c:\Users\Espen\Desktop\Intraday\Textfiles\IQ\Intraday\*.csv) do bcp testminidatabase..CSVTest4 in %a -T -Smyserver -c'