Collections:
Defining Text Files as the DTS Data Source
How To Define Text Files as the DTS Data Source?
✍: Guest
If your data text file is ready to import, you can start the DTS wizard and define the text file as the data source following this tutorial:
1. Start the DTS wizard and click Next. The data source window shows up.
2. Select "Text File" as the Data Source driver and enter C:\temp\fyi_articles.tab as the File Name. Then click Next. The file format window shows up.
3. You should see several rows from the text file displayed in the preview section. File in all fields based on the following suggestions:
Delimited. The columns are separated by any character: Yes File type: ANSI Row delimiter: {CR}{LF} Text qualifier: <none> Skip rows: 0 First row has column names: Yes
4. Click Next. The column delimiter window shows up.
5. Select Tab. You should see the data rows and columns are properly displayed in the preview section.
6. Click Next. The destination window shows up. You are ready to follow the next tutorial to define a SQL Server database table as the DTS data destination.
⇒ Defining SQL Server 2005 as the DTS Data Destination
⇐ Preparing Data in Text Files for DTS to Import
⇑ SQL Server FAQs - Introduction to DTS (Data Transformation Services)
2024-01-19, 1347🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...