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, 1282🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...