I change the queryout file to a different path and the copy happened.  Thanks for all the suggestions. 

Now what I really want to do is queryout the...

I used Sue's advice and my script looks like this now:

truncate table QlikSenseData
insert into QlikSenseData
EXEC dbo.QLIK_EXEC_2017_2018
EXEC xp_cmdshell 'bcp "select * from Live_PTS.dbo.QlikSenseData" queryout "C:\Users\Public\Public...

Thank you Again for the replies.  Based on your good advice, I now have this script:

truncate table QlikSenseData
insert into QlikSenseData
EXEC dbo.QLIK_EXEC_2017_2018
EXEC xp_cmdshell 'bcp "select...

After the script fails with the error, I type
select * from #QlikTemp, and all the table rows are returned.   Perhaps it doesn't like the # symbol?

Thank you for your reply.  I used your suggestion and am testing the following in a SQL Server Mgmt Studio window.  The statements execute and the file #QlikTemp gets created,...