SQL Server 2014 with PowerShell v5 Cookbook

Creating folders in an SSIS package store and MSDB

In this recipe, we will see how to create a folder in the SSIS instance and package store.

Getting ready

For this recipe, we will create a timestamped folder prefixed with the word QueryWorks. Feel free to replace it with your folder name by changing the $newFolder variable.

How to do it...

These are the steps required to create folders in the package store and SSIS instance:

1. Open PowerShell ISE as an administrator.
2. Add the ManagedDTS assembly as follows:

   #add ManagedDTS assembly
   Add-Type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

3. Add the following script and run it:

   $server = "localhost" #create new app $app = New-Object "Microsoft.SqlServer.Dts.Runtime.Application" ...