David.Poole - Monday, March 5, 2018 1:31 AM
The major reason bcp is high-speed is because it is focused on a specific pipeline between a specific set of potential input/output formats.
SSIS is what you want for more formats or a customized pipeline. In my experience, a well-designed SSIS package can be as efficient as bcp in terms of raw performance, while providing more complete error and performance logging.
Having said that, what I'd really like is a BCP native-format file source/destination for SSIS.