I've managed to RegEx parse the log4net file but now want to push them into SQL. Can the properties option include "create the table" for me because I'm getting

'SQL table column "Message" data type is not compatible with SELECT clause item "Message" (type STRING) [Data supplied is of wrong type.] '

select DateTime, LogType, Message, Exception
into ProdLogs
from '\server\logfile.log'
where NOT (logType = 'INFO')