Activation properties should be determined at package design time. You can select a package to run in process of the client that called it (as a library package) or in a dedicated server process (as a server package).
Library Package
Select this option to run the package as a library package. A library package runs in the process of the client that creates it. This option is only available for clients on the computer on which the package is being installed and configured. Note that library packages offer no component tracking, role checking, or process isolation.
Server Package
Select this option to run this package as a server package. A server package runs in its own process on the local computer. Server packages support role-based security, resource sharing, process isolation, and process management (such as package tracking).
See Also
Setting MTS Package Properties, Setting MTS Transaction Properties, Setting MTS Authentication Levels, Locking Your MTS Package