InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:35:07 GMT20http://www.sqlservercentral.com/Forums/Topic1425629-2799-1.aspxAs 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 Fri, 01 Mar 2013 10:36:09 GMTgeorgieporgie