Collections:
Defining SQL Server 2005 as the DTS Data Source
How To Define SQL Server 2005 as the DTS Data Source?
✍: Guest
If you want to transform (export) data out of a SQL Server 2005 database table, you need to configure the DTS data source to connect the SQL Server 2005 server. The tutorial exercise below shows you how to connect to the local SQL Server 2005 server and select a table as the data source for a DTS data transformation transaction.
1. Run DTS DTS Import/Export Wizard and click Next. The data source selection window shows up.
2. Select "Microsoft OLE DB Provider for SQL Server" as the data source driver. Then fill the other fields with:
Server: LOCALHOST Use SQL Server Authentication: checked Username: sa Password: FYIcenter Database: FyiCenterData
Note that you can not enter the database name in the Database field. If you have entered Server, Username, and Password correctly, you should see all available databases from your database server showing in the dropdown list.
Click Next. If you see the destination window, your data source is defined correctly now. You are ready to continue with the next tutorial to configure the DTS data destination.
⇒ Defining Excel Files as the DTS Data Destination
⇑ SQL Server FAQs - Introduction to DTS (Data Transformation Services)
2024-01-31, 1358🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...