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 8:43 am

    #1980777

    Sue_H - Thursday, February 22, 2018 7:32 AM

    MadAdmin - Thursday, February 22, 2018 6:54 AM

    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

    Importing data from an existing file is not at all what they are doing though.
    They are getting all services and then for each service, get the service name, status and display name.
    But as the author explained, it's an example for using Invoke-SQLcmd.

    Sue

    Was showing the method, not the solution. Can be applied using any array or dataset.
    So, 

    $var = Get-Service

    Then use that as a parameter in the writedbatable commandlet.
    Simplifies the process into 2 lines.

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