How to Delete one object in an array of objects in PowerShell

Question

$ErrorActionPreference = "Stop";

# Not sure if I need to load all these assemblies
 Add-Type -Path 'C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\v4.0_15.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll';
 Add-Type -Path 'C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSPipelineWrap\v4.0_15.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.DTSPipelineWrap.dll';
 Add-Type -Path 'C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.PipelineHost\v4.0_15.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.PipelineHost.dll';
 # Add-Type -Path 'C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSPipelineWrap\v4.0_15.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.DTSPipelineWrap.dll';

$App = New-Object -TypeName Microsoft.SqlServer.Dts.Runtime.Application; 

$PackageFullPath = 'C:\SSISPackage.dtsx'; # This is the SSIS package and has some connection managers. 

$Package = $App.LoadPackage($PackageFullPath, $null, 0);

$Package.Connections # this gives an array of objects with connection managers and I would like to remove one of them. 

$Package.Connections | Get-member # Object: Microsoft.SqlServer.Dts.Runtime.ConnectionManager

$App.SaveToXml($PackageFullPath, $Package, $null) # Here I would like to save the package again and when I open the solution i Visual Studio I would like it to be gone.

I don't understand how both code samples relate to each other. Can you clarify? Also, a short example output of the pipeline that you want to filter, would be helpful. — zett42
– zett42, Commented Mar 12, 2022 at 21:21
As for the PowerShell command: If you capture its output in a variable, you'll get an array of objects (the Select-Object -Property * seems redundant). You're already filtering the list of services with Where-Object, so you can add another filter criterion to exclude the service you want to delete - rather than trying to delete it from the array after the fact (arrays don't support deletion). — mklement0
– mklement0, Commented Mar 12, 2022 at 21:22
@zett42: The code sample that can run is just an example of the shape of the result when I have $p.property. — xhr489
– xhr489, Commented Mar 12, 2022 at 21:30
@mklement0: The code with Get-Service is only an example of how the output looks when I have $P.property loaded from a file. — xhr489
– xhr489, Commented Mar 12, 2022 at 21:32
Understood, @xhr489, but my point was that you technically cannot delete an element from an array, because it is a fixed-size data structure. Your only option is to create a new array with the element of interest omitted. If $P.property already is an array, apply a Where-Object filter to it and capture the result in a(n invariably new) array. — mklement0
– mklement0, Commented Mar 12, 2022 at 22:03

mklement0 · Accepted Answer · 2022-03-13 13:02:09Z

1

$Package.Connections contains a Microsoft.SqlServer.Dts.Runtime.Connections instance, which has a .Remove() method.

Therefore - assuming you know the index, name, or ID of the connection to remove - do the following:

# Determine the the connection to remove, which can be specified
# as:
# "name, index, ID, or identity of the ConnectionManager object to remove."
$toRemove = 42 # sample index

$Package.Connections.Remove($toRemove)

edited Mar 13, 2022 at 13:02

answered Mar 13, 2022 at 3:11

mklement0

452k68 gold badges727 silver badges986 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

xhr489 Over a year ago

You use the word "instance" above. Can you please explain when something is an instance?

mklement0 Over a year ago

@xhr489, thanks for pointing out the typo - fixed now. Instance is another way of saying object, and is typically used to refer to an object as a concrete embodiment of its type (class).

Collectives™ on Stack Overflow

How to Delete one object in an array of objects in PowerShell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related