帮我自动化SSIS工作 [英] Help me automate ssis jobs

问题描述

我与一家新公司合作，现在他们正在使用SSIS程序包，这些程序包在SQL作业中.与步骤.我可以创建一个可以控制所有工作的工作吗?他们希望我创建一个表，其中存储了所有作业，存储的过程和作业计划，并且我将创建的作业将从该表中提取要按顺序执行的作业.请帮助我了解我将如何执行此操作.

非常感谢！

解决方案

使用foreach循环:
http://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/ [
http://sqlserverrider.wordpress.com/2011/05/17/execute -sql-job-using-ssis/ [执行SQL Server代理作业任务 [使用C#管理SQL Server代理作业 [ ^ ]

Hi iam with a new company now they are using SSIS Packages and these packages are in SQL jobs. with steps. can i create a job that will controll all the jobs? they want me to create a table where all the jobs,stored proceedures and the schedules of jobs are stored and the job that i will create will fetch from the table what job is to be executed in sequence. Please help me to have an idea how iam gonna do this.

Thank you very much!

解决方案

Use foreach loop:
http://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/[^]

Then use "Execute SQL Server Agent Job Task" and set your variable for expression for this task.

http://sqlserverrider.wordpress.com/2011/05/17/execute-sql-job-using-ssis/[^]

You may also try sp_startjob stored proc too:
Execute SQL Server Agent Job Task[^]

You can also use Script Task to Run SQL Agent Job, have a look at :
Manage SQL Server Agent Jobs using C#[^]

这篇关于帮我自动化SSIS工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！