Writing Powershell for BI SSIS 2012 project package deployment

• georgieporgie

  Valued Member

  Points: 72

  More actions

  March 1, 2013 at 10:36 am

  #271736

  As a Powershell newbie, I want to write a PowerShell script that will execute on the production server and create all the necessary objects from dev. for the SSIS 2012 project/packages needed. I need a Powershell script that can

  1. Create the SSISDB Catlalog

  2. Deploy the SSIS 2012 project/packages to the catalog.

  3. Create the sql agent job that will execute on a daily schedule one of the parent packages in the catalog.

  4. Execute 4 of the SSIS packages in the SSISDB catalog that will create the BI staging databases, tables and other stuff.

  Does anyone have a Powershell script that does a SSIS 2012 deployment. I have found nothing on the web to show me the syntax. The ????? below is an example of where no samples exist for the jobstep command.

  $jobStep.Subsystem = [Microsoft.SqlServer.Management.Smo.Agent.AgentSubSystem]::SSIS

  $jobStep.Command = ?????????????

  Thanks for any help or guidance to a resource