How to read the file name , properties and insert the record in SQL Table
I have to read my daily log files which comes in the log folder from a third party application and make an entry in our log table as File Name, Date, File Folder Path.
How should i do this ? SQL has to run as a Trigger to read the folder on certain interval.
How should i do this ? SQL has to run as a Trigger to read the folder on certain interval.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
ASKER
Can we get the file name, date also along with the file folder path