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

CAST and CONVERT (Transact-SQL) - SQL Server

Ian Bradshaw

Use a Format File to Skip a Table Column (SQL Server) - SQL Server

How to handle 100 million rows with SQL Server BCP

SQL Server BCP Utility incorrect data import - Stack Overflow

Bulk load error: While reading current row from host, a premature

Ian Bradshaw

TSQL: Bulk load data conversion error (truncation) for row n

How to handle 100 million rows with SQL Server BCP

sql server - Import CSV File - Database Administrators Stack Exchange

Bulk Insert Data into SQL Server