In addition to storing packages in a COM-structured storage file, you can also store packages in the msdb database. Packages are saved as binary large objects (BLOBs) using the image data type in the sysdtspackages table. These packages are displayed in the SQL Server Enterprise Manager console tree in the Local folder under Data Transformation Packages.
Packages stored in SQL Server Storage are available to users that log on to the server with sufficient permissions to view local DTS packages.
The names of packages stored in SQL Server storage are required to be unique. No two packages with the same name can be stored in SQL Server storage. On servers installed with a case-sensitive sort order, names with the same set of characters can be saved if they use a different case for at least one of the letters. For example, two packages with the names abc and Abc can be saved, but not two packages with the names abc and abc. On servers installed with a case-insensitive sort order, the case of the package name is ignored.