.DTSCONFIG File Extension

SSIS Package Configuration File

Developer Microsoft
Popularity
2.8  |  4 Votes
 

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 or reference DTSCONFIG files

Windows

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.