I suggest you ...

Add the Create Table Option when exporting to SQL

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')

7 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Michael Blake shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base