Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard 
Author Message
 Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

   I'm having a problem with exporting data from text files(received
by e-mail) into SQL Server 2000 Database. These files
were created by dumping the data from SQL Server 7
tables. Each row of
these files has a fixed length and  no special delimeters
between the fields - only spaces.The Wizard detected the import file as a
file with delimited fields(Screen "Select file format"). The next screen of
the Wizard detected the column
delimeter as "other", but I couldn't detect the character. As
soon as put in the delimeter field spaces, it gave me the wrong
number of colums in the result SQL Server Table( = junk).
    If I defined the file as a file with fixed length, the next screen
of  the Wizard I got the fields with
offset(they were not left justified). When I copied this file into
the database, I got the table with the wrong number of fields
and rong data in them.
Can anybody tell me, what is the problem and is it really
possible to import the data this way ?

Any suggestions are appreciated.

Sergei Cher



Mon, 26 May 2003 03:00:00 GMT
 Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

Sometimes with the wizard you need to make sure you have all the settings
just right. Don't assume it detects any of them correctly. But if you are
going from SQL7 to 2000 then I would suggest using BCP with the native mode.
This is the fastest and there will be no mistaking the data types, columns
etc.

--
Andrew J. Kelly
Targitmail.com


Quote:
>    I'm having a problem with exporting data from text files(received
> by e-mail) into SQL Server 2000 Database. These files
> were created by dumping the data from SQL Server 7
> tables. Each row of
> these files has a fixed length and  no special delimeters
> between the fields - only spaces.The Wizard detected the import file as a
> file with delimited fields(Screen "Select file format"). The next screen
of
> the Wizard detected the column
> delimeter as "other", but I couldn't detect the character. As
> soon as put in the delimeter field spaces, it gave me the wrong
> number of colums in the result SQL Server Table( = junk).
>     If I defined the file as a file with fixed length, the next screen
> of  the Wizard I got the fields with
> offset(they were not left justified). When I copied this file into
> the database, I got the table with the wrong number of fields
> and rong data in them.
> Can anybody tell me, what is the problem and is it really
> possible to import the data this way ?

> Any suggestions are appreciated.

> Sergei Cher



Tue, 27 May 2003 21:26:19 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Access 2000 to SQL Server 2000 using Import/Export Wizard or DTS

2. DTS Wizard will not import/export between SQL Server Databases

3. Importing SAS dataset via DTS Import/Export Wizard

4. using DTS to import a text file in SQL Server 7.0 with VB6

5. DTS Import Export Wizard (file size bug??)

6. DTS Import/Export Wizard Error:GetSourcesRowset post SQL worm infection and SP2 SQL srvr upgrade

7. Help Importing a text file with DTS Wizard

8. DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

9. DTS Import Error When Importing Text File

10. using DTS to import Excel data into SQL Server 2000

11. DTSRun call using MSDE version of DTS aka Export/Import w/o SQL Server


 
Powered by phpBB® Forum Software