what type of data manupulation?
you can always load thatn 40 000 recs with DTS to a tempory table and then perform data manipulation with a tsql function or embeded .net funtion and save the recs to the final table.

>Assume there is data manipulation that requires loading through code. Now what is the best performance?