Understanding the Differences between Local and Remote Execution

新建日期: 2006 年 4 月 14 日

Package developers and administrators should be aware that there are restrictions related to where an Integration Services package runs.

  • A package runs on the same computer as the program that launches it. Even when a program loads a package that is stored remotely on another server, the package runs on the local computer.
  • You can only run a package outside the development environment on a computer that has Integration Services installed. You cannot run packages outside of Business Intelligence Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. To run packages from a client computer, you need to launch them in a manner that ensures that the packages run on the server.

For more information about loading and running a saved package, see:

For more information about running a package and loading its output into a custom program, see:

请参阅

任务

Loading and Running a Local Package Programmatically
Loading and Running a Remote Package Programmatically
Loading the Output of a Local Package

帮助和信息

获取 SQL Server 2005 帮助