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, 1273🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...