Article ID: 282463 - View products that this article applies to.
This article was previously published under Q282463
Any user who has a valid login for Microsoft SQL Server can create a package and then save the package to your computer that is running SQL Server. However, in an Enterprise environment that has many users, if everyone who has a valid login for SQL Server creates and saves Data Transformation Services (DTS) packages to the local computer that is running SQL Server, the SQL Server performance will be decreased.
If many packages are saved to the repository, performance will be decreased on the computer that is running SQL Server.
When you save a package to Meta Data Services, the DTS package protection options are not available. However, one advantage of saving packages to the repository is that it enables users to use the built-in versioning feature. Packages are saved together with a version ID that is displayed as the different dates and times that the package is opened and saved.
If package security is important, consider saving the package to SQL Server as a local server package or as a structured storage file instead. For more information about the various methods of saving DTS packages, refer to SQL Server Books Online.
You can use any of the following options to prevent users from saving DTS packages or to prevent them from viewing other users' packages.
Contact us for more help
Connect with Answer Desk for expert help.