Best way to bulk insert records to sqlserver ??

Hi

If you have the data sitting in another data source and you just want to move it to a different place, i think SSIS is your solution.

If you need to do it within your application after some processing is done on each row, you could go with SqlBulkCopy or even use table variables to fill in a datatable and pass all the rows to a stored proc and then do a SELECT INSERT in the stored proc.

Regards

Aram