Purchase Solution

Data Transformation Services

Not what you're looking for?

Ask Custom Question

How can Data Transformation Services (DTS) be used for data manipulation in SQL Server?

Purchase this Solution
Solution Summary

Data Transformation Services for data manipulation in SQL Server is explained.

Solution Preview

Microsoft DTS is a data manipulation tool.

It could be used for moving data between various formats and systems such as databases, spreadsheets, and even HTML. On can use Import/Export Wizard that is included with DTS for these operations .

Using DTS one can copy tables to FTP sites, and even script his/her own tasks.

DTS use example
===========
* Choose an ODBC data source to read data from.
* Then select an ODBC data source to convert the data to. You are then ...

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

View More Free Quizzes
Related BrainMass Solutions

  • Applying The Transformation Process to Goods and Services

    289013 Applying the Transformation Process to Goods and Services Can the transformation process be applied to both goods and services? How might data be used during the process?

  • What is the Transformation Process?

    367930 What is the Transformation Process? A. What is the transformation process? B. Can the transformation process be applied to both goods and services? C. How might data be used during the process?

  • Exporting and Importing Data

    Also note, SQL Server Integration Services. ============================= SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server 2005. It replaces Data Transformation Services, a feature of SQL Server since Version 7.0.

  • E-Bay

    Specifically the characteristics of digital media that have supported eBay's growth are the transformation of analog signal to digital signal, the transformation of data through high performance digital hardware, the use of digital programming for instant

  • Congnivist Theories in Consumer Behavior

    It gives considerable thought to the psychological process of sorting and recording data and details into either short term memory or long term memory.

  • Management Techniques on Productivity

    They undergo the transformation process depending on the industry (manufacturing, retail, etc.) and eventually produce output in the form of goods and/or services.

  • Restaurant transformation of inputs (food) to quality outputs

    338508 Restaurant transformation of inputs (food) to quality outputs If a restaurant purchases high quality ingredients as input to an output (food) and the service is not good, did the transformation of goods and services happen as expected?

  • Non-Linear Scatterplot

    Draw the scatterplot of this data. Observe that the shape is not linear. How can you best describe the shape? 2. Create a new set of data using the transformation y' = sqrt(y).

  • HEWLETT PACKARD

    The emphasis of the transformation is on five major elements, which are portfolio management, human resource efficiency, next-generation world class information, data centers, and data warehouse (Lewis, & Slack, 2003).

View More Related Solutions