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, 1341🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...