.DTSCONFIG File Extension

.DTSCONFIG File Extension

File Type

SSIS Package Configuration File

Developer Microsoft
Popularity
2.8  |  4 Votes
Category Settings Files
Format XML

What is a DTSCONFIG file?

A DTSCONFIG file is an XML configuration file used to apply property values to SQL Server Integration Services (SSIS) packages. The file contains one or more package configurations that consist of metadata such as the server name, database names, and other connection properties to configure SSIS packages.

More Information

The DTSCONFIG file is used to update the values of package properties and package objects at run time. the file is designed to provide flexibility when working with SSIS packages and are especially helpful when deploying packages to different environments as they allow values, such as server and database names, to be easily changed.

The DTSCONFIG file is made up of various elements. The DTSConfigurationHeading element stores the attributes and their values that define when and how the file is generated. The DTSCONFIG file also includes a Configuration element for each package configuration, which contains attributes and their values that are necessary to determine which property is being referenced. Each Configuration element has a ConfiguredValue element that features the property's actual value.

SQL Server is a relational database management system (RDBMS) application. SSIS packages are used to automate extraction, transformation, and loading (ETL) operations to and from a database.

NOTE: DTSCONFIG files often contain sensitive information, therefore, access to the location of the files should be restricted.

Common DTSCONFIG Filenames

DataTransferConfig.dtsConfig - A configuration file that contains name-value pairs that update the properties in packages to specify the location of the data and log files used by the package.

LoadXMLData.dtsConfig - Another configuration file that contains name-value pairs that update the properties in packages to specify the location of the data and log files used by the package.

Open over 400 file formats with File Viewer Plus.Free Download

Programs that open DTSCONFIG files

Windows
Updated April 12, 2016

Verified by FileInfo.com

The FileInfo.com team has independently researched the SSIS Package Configuration file format and Windows apps listed on this page. Our goal is 100% accuracy and we only publish information about file types that we have verified.

If you would like to suggest any additions or updates to this page, please let us know.