I have a CSV file which has some amount of data for which we are planning to move the data to a DB2 table (its only one time job). So I was planning of something using BulkInsert (sorry if I am wrong as I don't have any knowledge of DB2) through C# code. So please suggest how to write the code in C# to use DB2 bulkinsert functionality, also is it preferable to use the bulkinsert operation or is there any other best possible way. Currently I am thinking of running through each list item and calling insert statement on the table.
Thanks in advance.