Home : File Types : DTSCONFIG File

.DTSCONFIG File Extension

File TypeSSIS Package Configuration File

DeveloperMicrosoft
Popularity
2.0 (2 Votes)
CategorySettings Files
FormatXML

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.

FREE DOWNLOAD
Open over 300 file formats with File Viewer Plus.
Programs that open DTSCONFIG files
Updated 4/12/2016

About DTSCONFIG Files

Our goal is to help you understand what a file with a *.dtsconfig suffix is and how to open it.

The SSIS Package Configuration file type, file format description, and Windows programs listed on this page have been individually researched and verified by the FileInfo team. We strive for 100% accuracy and only publish information about file formats that we have tested and validated.

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