This pull request introduces a new BCPClient class to facilitate bulk copy operations in the mssql_python package. It includes comprehensive error handling, logging, and support for various configurations, making it easier to integrate bulk data operations with SQL Server. Additionally, the package's __init__.py file has been updated to expose the new BCP-related modules.

New Bulk Copy Functionality:

• BCPClient class added: Implements bulk copy operations using the BCP utility, with methods for initialization and execution. It includes robust validation for input parameters (connection, options, table) and detailed logging to aid debugging.
• Support for configuration options: The sql_bulk_copy method supports custom configurations via the BCPOptions class, including file paths, query hints, and column definitions.

Package Initialization:

• __init__.py updates: Added imports for BCPOptions, ColumnFormat, and BCPClient to make them accessible at the package level.

ADO

• USER STORY 34946