How To Import Txt Log File Into Sql Server
IF EXISTS ( SELECT NULL FROM dbo.sysobjects WHERE name = 'temp_LogFileImport' ) TRUNCATE TABLE DBA.dbo.temp_BingoLogFileImport ELSE CREATE TABLE temp_BingoLogFileImport ( line VARCHAR(8000) ) DECLARE @filename NVARCHAR(MAX) SELECT @filename = 'C:\demo\MyLogFile.log' EXEC ('bulk insert dbo.temp_LogFileImport from "' + @filename + '"')