Pls provide me info that how can i store DTS pacakage in repository and what is the benefit in saving in repository?

Manish

Hi,

To store a DTS package in a repository the following steps have to be followed:

1. In Data Transformation Services (DTS) Designer, on the Package menu, click Save.
2. In the Location list, click Meta Data Services.

Saving your DTS package on Meta Data Services means that you are storing your package in the SQL Server 2000 repository which are actually some tables in the msdb database.

The benefit of saving your DTS packages to the repository is that you can keep track of the data lineage. E.g.: What were the data that you traansfered on what day using what package to what destination, and the like.

Regards

Gogula G. Aryalingam (MVP - SQL Server)

Hi Gogula,

Once a DTS package is saved in repository, what are the tables that are used to keep track on data lineage in msdb?

How will be effect of this on size of the database?

Are there any links to read on DTS data tracking?

Regards,