Update SSIS package with a new var name or such

UpdateVarName.ps1

$dtsFiles = Get-ChildItem "C:\GIT\BusinessIntelligence\" -Filter *.dts

Foreach($dtsFile in $dtsFiles)
{
    Write-Host $dtsFile.FullName
    $dtsContents = Get-Content $dtsFile.FullName
    
    $dtsContents = $dtsContents -replace "audit.USP_ErrorLog", "[Audit].[USP_ErrorLog]"
    $dtsContents = $dtsContents -replace "audit.USP_JobLog", "[Audit].[USP_JobLog]"
    $dtsContents = $dtsContents -replace "audit.USP_RunTableRowCounts", "[Audit].[USP_RunTableRowCounts]"
    $result = Set-Content $dtsFile.FullName $dtsContents -Encoding UTF8 # Need to set the encoding as PowerShell didn't honour the original and the (C) caused diff changes (and prob errors
}