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, 1247🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...