Collections:
SQL Server FAQs - Introduction to DTS (Data Transformation Services)
A collection of 10 FAQs on DTS (Data Transformation Services). Clear explanations and tutorial exercises are provided on using DTS to import data to SQL Server and export data from SQL Server; exporting tables to MS Excel files; importing tables from text files. Topics included in this collections:
Installing DTS on Windows XP Systems
Defining SQL Server 2005 as the DTS Data Source
Defining Excel Files as the DTS Data Destination
Copying a Table from Source to Destination
Preparing Data in Text Files for DTS to Import
Defining Text Files as the DTS Data Source
Please note that all answers and tutorials are based on SQL Server 2005 Express Edition. To follow tutorial exercises in this collection, you need to use test tables created from previous tutorial collections.
✍: Guest
2024-02-09, 1266🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...