SQLServerCentral Article on Importing Powershell Output into SQL Server

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:
  1. Export-CSV/BULK INSERT
  2. XML/XMLBulkLoad
  3. DataTable/SQLBulkCopy
See the article for details
 
 
Advertisements
This entry was posted in PowerShell. Bookmark the permalink.