» PowerShell: Find/Replace Template

20Oct/110

PowerShell: Find/Replace Template

Brandon had this in some of his maintenance plan code and I found myself using it a bit so I thought I'd blog about it. Here is a simple script that reads a file (C:\scripts\maintenanceplans\$sqlversion\template.dtsx), replaces certain placeholders (in this case, [SERVERNAME] and [BACKUPPATH]), then writes a new file with that content.

$serverName = "sqlserver1"

$backupPath = "D:\dbbackups"


# Read in the maintenance plan template and replace the place holders

$textTemplate = [IO.File]::ReadAllText(".\maintenanceplans\$sqlVersion\template.dtsx")

$textTemplate = $textTemplate.Replace("[SERVERNAME]","$serverName")

$textTemplate = $textTemplate.Replace("[BACKUPPATH]","$backupPath")


# Write the new package.  MUST use UTF8 encoding or it will break.

Set-Content -Encoding utf8 ".\out.dtsx" $packageContents

This particular script writes out XML files. If you are writing a plain text file, remove "-Encoding utf8" and you're set.