Application to read text file periodically and import it to Sql 2008r2 table
I am having a cobol application in novell s/w. which periodically exports live data into a text file in mapped drive which can be read by windows os. My job is to read this text file in the mapped drive and import into sql server in windows os.
I think the same can be achieved thro' integration services. Can expert suggest which one of the following is better
1. handling it thro integration services
2. Writing a separate vb.net application to achieve the desired result
The application should handle , data transportation errors and any other import errors gracefully and rollback the import in case of any error and thro up errmsg to the user.