The question of how to load Powershell output into SQL Server has been frequently asked in Powershell forums. The article,
Loading Data With Powershell is my attempt to answer the question by providing three methods you can use to load the output of any Powershell command into a SQL Server table.
The methods are:
- Export-CSV/BULK INSERT
See the article for details