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, 1333🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...