Understanding the Differences between Local and Remote Execution
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:
Loading and Running a Local Package Programmatically
Loading and Running a Remote Package Programmatically
For more information about running a package and loading its output into a custom program, see: