Data Transformation Services
- Data Transformation Services
-
Les DTS sont des services inclus dans le SGBD SQL Server 2000 qui facilitent l’extraction, la transformation et le chargement de données hétérogènes à l’aide de OLE DB, Open Database Connectivity (ODBC) ou des fichiers texte seulement dans n’importe quelle base de données OLE DB vers n'importe qu'elle autre base ou fichier CSV. Par ailleurs, DTS automatise la transformation des données en permettant à l’utilisateur d’importer ou de transformer des données automatiquement selon un calendrier régulier.
Cette technologie a été remplacée par SSIS à partir de SQL Server 2005.
Fonctionnalités
Voir Microsoft SQL Server
Voir aussi
SQL
Liens externes
Wikimedia Foundation.
2010.
Contenu soumis à la licence CC-BY-SA. Source : Article Data Transformation Services de Wikipédia en français (auteurs)
Regardez d'autres dictionnaires:
Data Transformation Services — Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS… … Wikipedia
Data Transformation Services — Data Transformation Services, oder DTS, ist eine Sammlung von Paketen, Komponenten und Hilfsprogrammen, die es erlaubt, Extract, Transform, Load Prozesse beim Import in oder Export aus einer Datenbank zu automatisieren. DTS sind in den Microsoft… … Deutsch Wikipedia
Data Transform Process — Dieser Artikel wurde aufgrund von inhaltlichen Mängeln auf der Qualitätssicherungsseite der Redaktion Informatik eingetragen. Dies geschieht, um die Qualität der Artikel aus dem Themengebiet Informatik auf ein akzeptables Niveau zu bringen. Hilf… … Deutsch Wikipedia
Transformation — (root transform ) may refer to:Transformation is also referred to as a turn.In science: * Transformation (geometry), in mathematics, as a general term applies to mathematical functions. ** Data transformation (statistics) in statistics. *… … Wikipedia
Data migration — is the process of transferring data between storage types, formats, or computer systems. Data migration is usually performed programmatically to achieve an automated migration, freeing up human resources from tedious tasks. It is required when… … Wikipedia
Data Intensive Computing — is a class of parallel computing applications which use a data parallel approach to processing large volumes of data typically terabytes or petabytes in size and typically referred to as Big Data. Computing applications which devote most of their … Wikipedia
Data integrity — in its broadest meaning refers to the trustworthiness of system resources over their entire life cycle. In more analytic terms, it is the representational faithfulness of information to the true state of the object that the information represents … Wikipedia
Data Web — refers to a government open source project that was started in 1995 to develop open source framework that networks distributed statistical databases together into a seamless unified virtual data warehouse. Originally funded by the U.S. Census… … Wikipedia
Data mining — Not to be confused with analytics, information extraction, or data analysis. Data mining (the analysis step of the knowledge discovery in databases process,[1] or KDD), a relatively young and interdisciplinary field of computer science[2][3] is… … Wikipedia
Data cleansing — Not to be confused with Sanitization (classified information). Data cleansing, data cleaning, or data scrubbing is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database. Used… … Wikipedia
