Get output of Array into a SQL Server Table

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  July 29, 2019 at 8:40 pm

  #3666956

  Below is my sample powershell code. Can i take output of an array and insert into  a table in sql server.

  
  
  cls
  
  $filepath='C:\Temp\Backup'
  
  #Get-ChildItem -path $filepath -Recurse -Include *.bak 
  
  #$allfiles=@(Get-ChildItem -path $filepath -Recurse -Include *.bak | select  name,length ,lastwritetime )
  
  $allfiles=@(Get-ChildItem -path $filepath -Recurse -Include *.bak  | sort LastWriteTime -Descending | select  name,length ,lastwritetime | select -First 2 )
  
  $allfiles
  
  
  
  
  

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  July 29, 2019 at 9:24 pm

  #3666962

  A few different ways. One quick way using the SQLServer module is to just add a Write-SqlTableData cmdlet at the end of the script you started:

  Write-SqlTableData -serverInstance YourInstanceName -database YourDatabaseName -TableName YourTableName -SchemaName YourSchemaName -InputData $allfiles

  You can find examples of different methods in the following article:

  6 methods to write PowerShell output to a SQL Server table

  Sue

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  July 30, 2019 at 4:16 pm

  #3667275

  Works. Thank you