asked
Lunching SSIS Project Deployment by a scheduler
Hello, I need to create some custom logs for my packages, and add the logs to different tables other than the Catalog table, witch is filled automatically by SSIS, to do so, I have to launch the Project Deployment to make automaticaly logs, then retrieve them to other tables, My question is can we Launch this Project Deployment with a scheduler ? and maybe the schedular can launch it by script ?
You can automate the project deployment and thus launch the deployment by scheduler as well. There are several ways. You can write some T-SQL script to handle the deployment, or you can write a PowerShell Script which can do all the work as well. For example: [SSIS 2012 Automation – Part 1: Deploy SSIS Project to SSIS Catalog][1] [SSIS 2012 Automation – Part 2: Create environment, map it to project and package level parameters and assign reference to project][2] [SSIS 2012 Automation – Part 3: Create SQL Agent Job which will execute SSIS package from SSIS catalog, Assign Environment Reference and Assign Schedule to Job][3] [1]:
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2013/10/08/ssis-2012-automation-part-1-deploy-ssis-project-to-ssis-catalog.aspx [2]:
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2013/10/08/ssis-2012-automation-part-2-create-environment-map-it-to-project-and-package-level-parameters-and-assign-reference-to-project.aspx [3]:
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2013/10/08/ssis-2012-automation-part-3-create-sql-agent-job-which-will-execute-ssis-package-from-ssis-catalog-assign-environment-reference-and-assign-schedule-to-job.aspx
18 People are following this question.
