Part of my series pointing to valuable instruction on the web.
Bulk Copy Data into SQL Server with PowerShell
The fastest way to get data into SQL Server is to use bulk copy methods, whether you use the old bcp utility or use the same capability in other ways.
Source: m.sqlmag.com/powershell/bulk-copy-data-sql-server-powershell