1 out of 1 rated this helpful - Rate this topic

Dependency Services

[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.

Option	Description
-F	Directory path to install the DependencyCatalog database to.
-S	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.
Copy
USE DependencyCatalogGOCREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'GO

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:

Unknown List Class

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Dependency Services

Community Additions