Configure the integration services service to solve the problem: the data cannot be retrieved for this request. (Microsoft. sqlserver. smoenum)

An error occurred while expanding integration services: data cannot be retrieved for this request. (Microsoft. sqlserver. smoenum)
Solution: you can modify the configuration file to solve the problem:
Also see SQL Server 2005 books online: configure the Integration Services Service

Microsoft SQL Server 2005 integration services (SSIS) contains a configuration file used to configure the integration services service.

By default, the file is located in the folder Program Files \ Microsoft SQL Server \ 90 \ DTS \ binn, and the file name is msdtssrvr. ini. xml.

The default configuration file contains the following settings:

• The Stop command is sent to the package when the service is stopped.
• In the object Resource Manager of SQL Server Management Studio, the root folders displayed for integration services are MSDB and file system folders.
• Packages in the file system managed by the Integration Services Service are located in % Program Files % \ Microsoft SQL Server \ 90 \ DTS \ packages.

You can modify the configuration file to allow the package to continue running when the service is stopped. Other root folders are displayed in the object Resource Manager; you can also specify a different folder or other folders in the file system to be managed by the Integration Services Service.

The Registry item HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ msdts \ serviceconfigfile specifies the location and name of the configuration file used by the Integration Services Service. The default value of this registry item is c: \ Program Files \ Microsoft SQL Server \ 90 \ DTS \ binn \ msdtssrvr. ini. xml. You can update the value of this registry key to use different names and locations for the configuration file.

You can solve this problem by changing the configuration file:Data cannot be retrieved for this request. (Microsoft. sqlserver. smoenum)

Default Configuration File

The following XMLCodeThe default configuration file example of integration services is displayed. It specifies the following content: When the integration services service is stopped, the package stops running, and the root folder in integration services is the packages in the MSDB, file system, and packages folders, which are monitored by this service.

This file is used for the default instance of the SQL server instance.

<? XML version = "1.0" encoding = "UTF-8"?>
<Dtsserviceconfiguration xmlns: XSD = "http://www.w3.org/2001/XMLSchema" xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance">
<Stopexecutingpackagesonshutdown> true </stopexecutingpackagesonshutdown>
<Toplevelfolders>
<Folder xsi: TYPE = "sqlserverfolder">
<Name> MSDB </Name>
<Servername>. </servername>
</Folder>
<Folder xsi: TYPE = "filesystemfolder">
<Name> File System </Name>
<Storepath> .. \ packages </storepath>
</Folder>
</Toplevelfolders>
</Dtsserviceconfiguration>

Configuration file of the SQL Server naming instance

The following XML code shows an example of the modified integration services configuration file. This file is used for SQL Server naming instances.InstanceNameInServernameServer.

<? XML version = "1.0" encoding = "UTF-8"?>
<Dtsserviceconfiguration xmlns: XSD = "http://www.w3.org/2001/XMLSchema" xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance">
<Stopexecutingpackagesonshutdown> true </stopexecutingpackagesonshutdown>
<Toplevelfolders>
<Folder xsi: TYPE = "sqlserverfolder">
<Name> MSDB </Name>
<Servername> servername \ InstanceName </servername>
</Folder>
<Folder xsi: TYPE = "filesystemfolder">
<Name> File System </Name>
<Storepath> .. \ packages </storepath>
</Folder>
</Toplevelfolders>
</Dtsserviceconfiguration>
<? XML version = "1.0" encoding = "UTF-8"?>
<Dtsserviceconfiguration xmlns: XSD = "http://www.w3.org/2001/XMLSchema" xmlns: xsi = "http://www.w3.org/2001/XMLSchema-instance">