Instructions for loading the ITIS tables into the 
ITIS database for a MS SQL Server 2000 database

1. First "untar" the ITIS "TAR" file that now resides on your MS Windows PC.  
On MS Windows, you can use software like "Winzip" to do this.

2. Use MS Enterprise Manager to create a database called "ITIS" in
MS SQL Server 2000.

3. Create the schema for the "ITIS" database by using the file
"itisMS.sql". Note that the specified "owner" of the "ITIS" 
database is "dbo".
Start MS SQL Server 2000 and then choose 
  Tools 
and then select 
  SQL Query Analyzer
click on 
  File 
and then select 
  Open
enter the file 
  ItisMS.sql"
and then click on 
  open
next click on the 
  "blue check mark" (Parse Query) (Ctrl+F5) 
and then click on 
  Execute Query (F5).

4. Now use MS Enterprise Manager to load the tables into 
the "ITIS" database.
First click on:
  Tools
Then click on:
  Data Tranformation Services
Then click on:
  Import
Under "Data Source:" choose the option:
  Text file
Then click on "Next".
Repetitively choose each file for each table to be loaded.
For each of the 18 files enter:
Choose "Delimited".
File Type: ANSI
Row delimiter: {LF}
Text qualifier: <none>
Then click on "Next"
Specify Column Delimiter
Other: | (will be a "pipe")
Then click on "Next"

The order of the loading will be:
  1  comments
  2  experts
  3  geographic_div
  4  jurisdiction
  5  kingdoms
  6  nodc_ids
  7  other_sources
  8  publications
  9 taxon_authors_lkp
  10 taxon_unit_types
  11 tu_comments_links
  12 synonym_links
  13 taxonomic_units
  14 reference_links
  15 vernaculars
  16 vern_ref_links
  17 longnames
  18 strippedauthor

At this point, all 18 tables have been loaded into the
ITIS database.

