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 in errors

SQL Server BCP format file could not be opened. Invalid name

Dinesh's Blog :::: Being Compiled ::::: May 2017

Blog - Page 2 of 168 - Brent Ozar Unlimited®

Import Excel data into SQL Server using copy and paste

Bulk Copy Utility (BCP)

Handling error converting data type varchar to numeric in SQL Server

SQL Server BCP Import Skip and Map Columns Using Views

Exporting Data Using BCP – Bradley Schacht

Replication: Snapshot Agent fails on date conversion

CAST and CONVERT (Transact-SQL) - SQL Server