Can't load data to SQL Server

[TeamTJ]

I am trying to load a .csv file to SQL Server (Microsoft SQL Server 2019 on my local machine).

I'm using SQL Server Bulk Loader (as I have on other machines in the past for other processes) but when I run it I am getting an Output Data error along the lines of "Error opening "select <field1>, <field2> from table" No Columns Returned

Suggestions?

Thanks!

[IraWatt]

Hey @TeamTJ,

Does it work with the output data tool set to a normal ODBC connection? All that I can tell from that error is the column/table names may be wrong. If it works with ODBC it could rule out any syntax issues.