Database Reference
In-Depth Information
6.
Enter the SQL Server 2008 R2 instance name to choose the relevant package Export
Department Data, as shown in the following screenshot.
7. Now, let us look into how to automate the package execution for administrative
purposes without choosing any other tool or process. This SSIS job step presents
various execution options, such as Configurations.
8. SSIS service relies on a configuration, which stands as settings for all the packages
on that SQL Server instance. By default, the configuration file is stored as an XML
file, which can be located under the folder %ProgramFiles%\Microsoft SQL
Server\100\DTS\Binn with the name MsDtsSrvr.ini.xml.
9. You need to modify the configuration file, if your packages are stored in a named
instance, or a remote instance of the Database Engine, or in multiple instances of the
Database Engine.
10. If the configuration file is moved to a different location other than the earlier specified
default location, you have to modify the registry to specify the new location. The
registry key can be located in: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
Microsoft SQL Server\100\SSIS\ServiceConfigFile .
 
Search WWH ::




Custom Search