Collections:
Defining SQL Server 2005 as the DTS Data Destination
How To Define SQL Server 2005 as the DTS Data Destination?
✍: Guest
If you are importing data from text files to SQL Server 2005 database tables, you need to define SQL Server 2005 as the DTS data destination. This tutorial continues from the previous tutorial to show you how to tell DTS to create a new table in a SQL Server as the DTS destination.
1. Continue from the previous tutorial until you see the destination window.
2. Enter the following information:
Destination: Microsoft OLE DB Provider for SQL Server Server: LOCALHOST Use SQL Server Authentication: checked Username: sa Password: FYIcenter Database: FyiCenterData
3. Click Next. The destination table creation window shows up.
4. Review the destination new table name: [FyiCenterData].[dbo].[fyi_articles].
5. Click Transform to review new table column definitions. By default, DTS will create all columns as VARCHAR(255). Click OK to close the Transform window.
6. Click Next and follow the wizard to complete the import process.
7. Connect to SQL Server with SQLCMD to verify the imported new table.
⇒ Data Formats Supported by DTS
⇐ Defining Text Files as the DTS Data Source
⇑ SQL Server FAQs - Introduction to DTS (Data Transformation Services)
2024-01-19, 1357🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...