sql server - BCP copy out failed -- data type conversion & column

Context: I'm attempting to output the contents of a table in SQL Server to a CSV file via BCP. I'm trying to explicitly name the column headers in the CSV file by performing a UNION ALL so the column

BCP Utility, PDF, Microsoft Sql Server

sql server - SSIS: How to export more than 4000 characters to

Package

Handling error converting data type varchar to numeric in SQL Server

SQL Server BCP Utility incorrect data import - Stack Overflow

BCP Format file to bulk import in SQL Server throws ODBC error

Excel Import to SQL Server using SSIS

An introduction to the bcp Utility (bulk copy program) in SQL Server

How to handle 100 million rows with SQL Server BCP

Azure SQL Server AWS Blog