I have a very interesting problem with XML output from SQL query.

DECLARE @DateStr VARCHAR(30), @sql nvarchar (4000)
SET @DateStr = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(30), dateadd(HH,+2,getdate()),120),'.','-'),':','-'),' ','_');
SET @sql ='bcp "SELECT top 1  [Kod] ,[Ad] FROM [SMFT].[dbo].[AlanKonya]  FOR XML PATH(''Cubik'') ,ROOT(''CubicDetails'')" queryout "\\\cgtserver\Development\Cubik_FIFOREPORT_' + @DateStr + '.xml" -T -S CGTSAPP\CGTSSQL120 -w -r -t'
EXEC xp_cmdshell @sql

the Output file seems like this.[notepad++]

When I look with WinSCP editor it seems like this [WinSCP]

The file format looks like a text format

I just want to see like this [notepad++ ok ]

Why does my XML output look like a Text file when other XML files I open look formatted?

I'm having trouble transferring the file with WinScp because it appears as a text file

I'm using SQL 2012 Standard edition. I tried it in SQL 2016 enterprise but I took the same result

Could you help me, please?

Best regards

here is my new quert that is worked

DECLARE @FilePath VARCHAR(4000)DECLARE @SQLStr NVARCHAR(4000),
    @Cmd NVARCHAR(4000),
    @Ret INT,
    @DateStr VARCHAR(30), @sql nvarchar (4000)
SET @DateStr = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(30), dateadd(HH,+2,getdate()),120),'.','-'),':','-'),' ','_');
SELECT @SQLStr = 'SELECT N'''' + (SELECT CAST((SELECT * FROM [SMFT].[dbo].Cubik_FIFOREPORT FOR XML  PATH(''Cubik'') ,ROOT(''CubicFifoReport''), ELEMENTS XSINIL) AS NVARCHAR(MAX)))'
SELECT @SQLStr AS SQLStr
SELECT @FilePath ='\\cgtserver\DEVELOPMENT\Cubik_FIFOREPORT_' + @DateStr + '.xml'
SELECT @Cmd = ' bcp " ' + @SQLStr + '" queryout '+@FilePath+'  -c -r  "" -T -S ' +@@ServerName
EXEC @Ret = master.dbo.xp_cmdshell @Cmd