When using Bulk Insert statements to SQL Server, the transformation engine is limited to one statement per processor on the data server. On a data server, high concurrency combined with low processor count can result in a queue of bulk-insert requests. Therefore, locations that do not import a high volume of data should be switched to use the SQL Insert statement load method.
For successful execution of Bulk Insert statements against SQL Server, the SQL Server service account must be able to read data from the file-system repository.