Collections:
Copying a Table from Source to Destination
How To Copy a Table from Source to Destination?
✍: Guest
If the DTS data source is set to a SQL Server, you have two options to transform data from source to destination:
This tutorial continues from previous tutorials to copy a table from SQL Server to an Excel file:
1. Continue from previous tutorials until the data selection options window.
2. Select the "Copy table(s) and view(s) from the source database" option and click Next. You should see a list of tables available in the SQL Server defined as the data source.
3. Select table [FyiCenterData].[dbo].[fyi_links].
4. Click Next. The data transformation option window shows up.
5. Select "Run immediately". Then click Next. The confirmation window shows up.
6. Review source and destination settings. Click Finish. The transformation progress window shows up. Wait until the transformation is done. Click OK, when you see the transformation is done message.
7. Close DTS wizard.
You should see an Excel file created by DTS: C:\temp\fyi_links.xls
⇒ Preparing Data in Text Files for DTS to Import
⇐ Defining Excel Files as the DTS Data Destination
⇑ SQL Server FAQs - Introduction to DTS (Data Transformation Services)
2024-01-31, 1250🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...