3.10 Execute Package任务

本文介绍了SQL Server Integration Services (SSIS)中的ExecutePackage任务,该任务用于执行父程序包内的子程序包。文章详细解释了ExecuteOutofProcess属性的作用,并对比了与SQL Server 2000 DTS版本的不同之处。同时,还介绍了如何配置子程序包的执行位置,包括文件系统和SQL Server两种方式。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

3.10  Execute Package任务

Execute Package任务负责执行来自某个父程序包的另外一个子程序包。虽然该程序包在SQL Server 2000 DTS中也存在,但在SSIS中通过一些改进对该任务进行了简化。在该任务编辑器(如图3-16所示)的Package页面,可以看到新的ExecuteOutofProcess属性,该属性若设置为true,则将它自己的进程和内存空间中执行程序包。该属性的默认行为是设置为true,这会需要更多的内存但将改进性能。该任务的SSIS版本和SQL Server 2000版本之间的另外一个重要差别是,在SSIS中,该任务不再将参数传递给子程序包。相反,子程序包将进入到父程序包并提取配置值。

图  3-16

同样地,我们需要在Execute Package Task Editor中的Package页面中完成大多数配置工作。首先指向程序包打算去往的地方。这里的选项有File System和SQL Server。File System任务为.dtsx文件,SQL Server程序包则保存在SQL Server实例的msdb数据库中。如果选择File System,则必须首先通过从Connection下拉框中选择New Connection来创建一个到程序包的新Connection Manager连接。如果选择SQL Server,则将它指向到程序包所在的SQL Server的OLE DB Connection Manager连接。

-- stderr: diyiban CMake Deprecation Warning at CMakeLists.txt:1 (cmake_minimum_required): Compatibility with CMake < 2.8.12 will be removed from a future version of CMake. Update the VERSION argument <min> value or use a ...<max> suffix to tell CMake that the project does not need compatibility with older versions. Traceback (most recent call last): File "/home/ros2/catkin_ws/install/catkin/share/catkin/cmake/parse_package_xml.py", line 115, in <module> main() File "/home/ros2/catkin_ws/install/catkin/share/catkin/cmake/parse_package_xml.py", line 101, in main package = parse_package(args.package_xml) File "/usr/local/lib/python3.10/dist-packages/catkin_pkg/package.py", line 584, in parse_package return parse_package_string(xml, filename, warnings=warnings) File "/usr/local/lib/python3.10/dist-packages/catkin_pkg/package.py", line 788, in parse_package_string pkg.validate(warnings=warnings) File "/usr/local/lib/python3.10/dist-packages/catkin_pkg/package.py", line 330, in validate raise InvalidPackage(&#39;\n&#39;.join(errors), self.filename) catkin_pkg.package.InvalidPackage: Error(s) in package &#39;/home/ros2/ros2_ws/src/diyiban/package.xml&#39;: Package name "diyiban.SLDASM" does not follow naming conventions CMake Error at /home/ros2/catkin_ws/install/catkin/share/catkin/cmake/safe_execute_process.cmake:11 (message): execute_process(/usr/bin/python3 "/home/ros2/catkin_ws/install/catkin/share/catkin/cmake/parse_package_xml.py" "/home/ros2/ros2_ws/src/diyiban/package.xml" "/home/ros2/ros2_ws/build/diyiban/catkin_generated/package.cmake") returned error code 1 Call Stack (most recent call first): /home/ros2/catkin_ws/install/catkin/share/catkin/cmake/catkin_package_xml.cmake:74 (safe_execute_process) /home/ros2/catkin_ws/install/catkin/share/catkin/cmake/catkin_package_xml.cmake:50 (_catkin_package_xml) /home/ros2/catkin_ws/install/catkin/share/catkin/cmake/catkin_package.cmake:99 (catkin_package_x
最新发布
04-01
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值