Home Forums Article Discussions Article Discussions by Author Discuss content posted by Vishnu Gupthan Insert data into a SQL Server Table using Powershell using Invoke-SQLc RE: Insert data into a SQL Server Table using Powershell using Invoke-SQLc

  • February 22, 2018 at 6:54 am

    #1980762

    using DBATools

    $datatable = Import-Csv C:\temp\customers.csv | Out-DbaDataTable
    Write-DbaDataTable -SqlServer sql2014 -InputObject $datatable -Table mydb.dbo.customers

    Much better than foreach

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]