DTS Designer is a graphical design environment for creating and executing complex sets of data transformations and workflows, in preparation for moving data to a data warehouse. Experienced users can use DTS Designer to integrate, consolidate, and transform heterogeneous data from multiple sources. Packages created can be stored in a Microsoft® SQL Server™ msdb database, Microsoft Repository, or a COM-structured storage file.