Powershell generate XML file

Question

I have a powershell script that spool the result of an Stored Procedure in SQL Server into a DataTable. This DT has only one row that is an XML string:

#-----------------------
#-- XML file Creation --
#-----------------------
[String]$Step = "XML file Creation."
&{
  foreach ($row in $dt_table1.Rows){ 
  $row[0].ToString().Trim()
  } }| set-content $DestinationXMLFilePath

However, the output file generated by this creates a TXT file not in an XML format, if the line is too long it automatically put a new line to continue and this is not correct.

Is there a way to generate an XML in XML format?

"if the line is too long it automatically put a new line to continue and this is not correct." - can you show us such a line and what happens to it? — Mathias R. Jessen
– Mathias R. Jessen, Commented Apr 6, 2021 at 10:08

Giuseppe Lolli · Accepted Answer · 2021-04-06 09:56:02Z

1

I found a solution, adding the -NonewLine parameter to the code:

#-----------------------
#-- XML file Creation --
#-----------------------
[String]$Step = "XML file Creation."
&{
  foreach ($row in $dt_table1.Rows){ 
  $row[0].ToString().Trim()
  } }| set-content $DestinationXMLFilePath -NoNewLine

answered Apr 6, 2021 at 9:56

Giuseppe Lolli

1771 gold badge4 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tomalak Over a year ago

If your $dt_table1 only ever has one row anyway, you don't need a foreach loop.

Collectives™ on Stack Overflow

Powershell generate XML file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related