August 7, 2008 at 4:15 pm
I have a CSV formatted flat file which I need to read. I have to decide whether I should read the CSV flat file in and parse it in code or use the ODBC connection to treat it like it is a database.
Could anyone please give me ides which will be best approach for me? Any link will be highly appreciated. 😀
August 7, 2008 at 6:36 pm
Hi Utsab
It entirely depends on what you want to achieve.
If the contents of file are going to be updated too frequently, i would suggest to load the file to a table using bcp, ssis, bulk insert or any other method, run what ever processes you want to and then (if required) export the file back to csv.
if it is once off load, you can create an ODBC connection and fetch the data from csv file.
August 7, 2008 at 9:08 pm
nothing in my mind at the moment. would say go google. 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply