| title | Understanding the Differences between Local and Remote Execution | |||
|---|---|---|---|---|
| description | Understanding the Differences between Local and Remote Execution | |||
| author | chugugrace | |||
| ms.author | chugu | |||
| ms.date | 03/17/2017 | |||
| ms.service | sql | |||
| ms.subservice | integration-services | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
Package developers and administrators should be aware that there are restrictions related to where an [!INCLUDEssISnoversion] 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 [!INCLUDEssBIDevStudioFull] on a client computer that does not have [!INCLUDEssISnoversion] installed, and the terms of your [!INCLUDEssNoVersion] licensing may not permit you to install [!INCLUDEssISnoversion] on additional computers. [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] is a server component and is not redistributable to client computers. 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