• David.Poole - Monday, March 5, 2018 1:31 AM

    I think bcp could do with enhancements.  As a high speed import/export tool it has served me well.  The ability to handle parquet/Orc files would be fantastic.  Far more cross platform data exchange takes place these days as the love affair with data lakes continues

    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.