March 1, 2013 at 10:36 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy