powershell - 远程作用域到本地

非常感谢@brianlist，我尝试了您的建议，将其与bulkcopy结合使用时会出现此错误，不确定该值是否传递给$value。

Cannot convert argument "0", with value: "System.Object[]", for "WriteToServer"
to type "System.Data.DataRow[]": "Cannot convert the "System.Data.DataRow" value
of type "Deserialized.System.Data.DataRow" to type "System.Data.DataRow"."
At C:\test\modified.ps1:11 char:24
+ $bulkCopy.WriteToServer <<<< ($value)
    + CategoryInfo          : NotSpecified: (:) [], MethodException
    + FullyQualifiedErrorId : MethodArgumentConversionInvalidCastArgument

Get-Content 'C:\test\computers.txt' | ? { $_.trim() -ne "" } | ForEach-Object {
    $value =  Invoke-Command -Computer $_ -ScriptBlock {
        Param($computer)
        #..
        $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
        $global:mdtable = New-Object System.Data.DataTable
        $SqlAdapter.SelectCommand = $SqlCmd
        $nRecs = $SqlAdapter.Fill($mdtable)
        $mdtable
    } -ArgumentList $_ -Credential $cred
} | test

Function test {
    $Database = 'Test1'
    $table = 'dbo.table_2'
    $connectionstring = "Data Source=mylocal;Integrated Security=True;Initial Catalog=$Database"
    $Conn  = New-Object System.Data.SqlClient.SQLConnection($connectionstring)
    $conn.open()
    $bulkcopy = New-Object Data.SqlClient.SqlBulkCopy($conn)
    $bulkcopy.DestinationTableName = $table
    $bulkCopy.WriteToServer($value)
    $conn.close()
}

最佳答案

您已经从$mdtable脚本块返回了Invoke-Command的值。要获得该值以外的值，只需将Invoke-Command的结果赋给一个变量:

Get-Content 'C:\test\computers.txt'| ? {$_.trim() -ne "" } | ForEach-object{
    $value = Invoke-Command -Computer $_ -ScriptBlock {
        Param($computer)
        # ...
        $mdtable
    }

在此示例中，$value将包含$mdtable所具有的内容。

关于powershell - 远程作用域到本地，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/34120978/