[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
Dependency Services enables you to extract impact and data lineage information for Integration Services and SQL Server objects, and to view the information.
For more information about extracting impact and data lineage information, see Extracting Impact and Data Lineage Data.
For more information about viewing impact and data lineage information, see Determining Impact and Data Lineage.
To use Dependency Services, you must install the DependencyCatalog database.
To install the DependencyCatalog database
Open a Command Prompt window, and then change to the directory that contains IALSetup.cmd (<drive>:\Program Files\Microsoft SQL Server\110\DTS\Binn).
Run IALSetup.cmd using the following options.
Directory path to install the DependencyCatalog database to.
SQL Server instance name
The following is the command syntax.
IALSetup.cmd -f "[value]" -s [value]
In the following example, the DependencyCatalog database is installed to the C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA folder.
ialsetup.cmd -f "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA" -s localhost
Create a master database key for the DependencyCatalog database by running the following query.
USE DependencyCatalogGOCREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'GO