We have a stored procedure that calls xp_cmdshell in order to use the BCP command. This SP works in SQL 2017 and 2019, but I am testing SQL 2022 in our environment and this SP does not work. I'm hoping to get some help in determining what is wrong.
Error: [Microsoft][ODBC Driver 17 for SQL Server]Unable to load xmlrw.dll while attempting to read xml format file.
BCP Version: 16.0.1000.6
SQL Version: Microsoft SQL Server 2022 (RTM-CU4) (KB5026717) - 16.0.4035.4 (X64) May 1 2023 10:34:45 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2022 Datacenter 10.0 <X64> (Build 20348: ) (Hypervisor)
Note: I am able to run the same command on previous versions of SQL
Things we've tried:
- Installing ODBC driver 18 for SQL server. I think BCP continues to use ODBC 17 once this is installed
- Uninstall ODBC 17. This causes BCP to fail
- Install SQL CU4
Thanks in advance for any help!