Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Writing Powershell for BI SSIS 2012 project package deployment Expand / Collapse
Posted Friday, March 1, 2013 10:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 10, 2015 3:32 AM
Points: 2, Visits: 95
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

Post #1425629
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse