This is a related question, hoping someone on this thread can answer it.

I've had a working bcp process for months that creates a CSV file on a network drive. Here's the command:

'bcp "exec [dbname].[dbo].ExtractData" queryout ' + @destFolder + @fileName + ' -t \, -T -c'

When @destFolder = "\\[server_name]\UploadFiles" it works

If I change @destFolder to: "\\[server_name]\9 Auto Generated Upload Files\" with spaces in the folder name, it doesn't work.

I can work around this, but does anyone know of a way to force bcp to accept spaces in the destination folder?

Thanks in advance,