Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Friday, March 01, 2013 10:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, March 03, 2013 7:17 PM
Points: 2, Visits: 92
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