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, 1263🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...