Having the same problem, but I need to use BULK INSERT. I will be inserting > 150K records and I don't think anything else is as good as Bulking.

BULK INSERT MYLINKEDSRV.myDatabase.dbo.BCPTable

FROM 'C:\list.csv'

WITH (FORMATFILE = 'C:\format_file.xml')

Milford