The snippet below will create the given project folder in your target SSIS Catalog Database, but only if it does not exist yet, making the script safe for use in an incremental deployment process.
One of the very few annoyances of using the SQL PowerShell Provider becomes apparent when you import its module. Your current location, probably a working folder somewhere in your file system, will get overridden by the default location of the new provider.
What’s the only thing better than replacing multiple strings in text files using powershell? Why, doing it with regular expressions, of course! Here’s how.
Ever had to do an unusual high number of find-replacements on an even higher numbered group of files? Remember despairing at the ticking clock while you ached through them one by one? We both know the pain then. Let’s avoid that in the future with some powershell sugar.