Microsoft integration services

Installing the Feature Pack lets your packages connect to storage and analytics services in the Azure cloud, including the following services:. Optional additional components. Microsoft Connectors for Oracle and Teradata by Attunity. To get these components, see Attunity connectors. For more information about Integration Services installation and feature updates, see the following articles:. Skip to main content. This browser is no longer supported.

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? You can also view service events by using the Windows Event Viewer. When you first install SQL Server Integration Services, the Integration Services service is started and the startup type of the service is set to automatic.

To configure other important features of the service, including the locations where it stores and manages packages, you must modify the configuration file of the service. Click the Service tab to view information about the service such as the name of the host computer and to specify the start mode of Integration Services service.

Click the General tab. To enable the service, select either the manual or automatic startup type. To disable the service, select Disable in the Startup type box. Selecting Disable does not stop the service if it is currently running. If the service is already enabled, you can click Stop to stop the service, or click Start to start the service. Click the Recovery tab to view the default computer responses to service failure. You can modify these options to suit your environment.

Click the Dependencies tab to view a list of dependent services. The Integration Services service has no dependencies. On the File menu, click Exit to close the Services snap-in.

The service is secure by default. After SQL Server is installed, the administrator must grant access to the service. Run Dcomcnfg. When you install Integration Services, the setup process creates and installs the configuration file for the Integration Services service.

This configuration file contains the following settings:. This configuration file also specifies which msdb database contains the packages that the Integration Services service will manage. The service manages packages that are stored in the msdb database of the local, default instance of SQL Server.

You can modify the configuration file to allow packages to continue running if the service stops, to display additional root folders in Object Explorer, or to specify a different folder or additional folders in the file system to be managed by Integration Services service.

For example, you can create additional root folders of type, SqlServerFolder , to manage packages in the msdb databases of additional instances of Database Engine. Some characters are not valid in folder names.

Valid characters for folder names are determined by the. NET Framework class System. Path and the GetInvalidFilenameChars field. The GetInvalidFilenameChars field provides a platform-specific array of characters that cannot be specified in path string arguments passed to members of the Path class. The set of invalid characters can vary by file system. However, you will have to modify the configuration file to manage packages that are stored in a named instance or a remote instance of Database Engine.

If you do not update the configuration file, you cannot use Object Explorer in SQL Server Management Studio to view packages that are stored in the msdb database on the named instance or the remote instance. If you try to use Object Explorer to view these packages, you receive the following error message:.

This might occur when there is no default instance of SQL Server on the computer. An error has occurred while establishing a connection to the server. When connecting to SQL Server , this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. After you modify the service configuration file, you must restart the service to use the updated service configuration.

The following example shows a modified configuration file for Integration Services. You can update the value of the Registry key to use a different name and location for the configuration file.

For installation instructions and guidance, see Install Integration Services. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.