[dba-SQLServer]SQL Import Spec

Why do you need to do another import using Access?
 
Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
* (210) 913-3148 - phone
* (210) 753-3148 - pager

 
-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
Sent: Friday, April 25, 2003 2:39 PM
To: SQLServerList
Subject: [dba-SQLServer]SQL Import Spec
 
I have been loading gigs and gigs of data into our SQL Server for the past month.
The process is fairly time consuming:
1.      Import a 16 GB text file into a 1 field SQL table
2.      Run a sproc to separate records into 7 different tables based on record layout
3.      Export each of the 7 tables from SQL to text
4.      Import each of the 7 text files into linked SQL tables using Access import specs.
 
I need to do this for almost 70 16 GB text files.  Each file takes about a day to fully load.
Is there a way to expedite this process?  I am really looking for a way to save an import spec in Enterprise Mgr.
That way, I can omit using Access and run the whole process as a SQL job, with very minimal human interaction.
Any direction is greatly appreciated.
 
Thanks,
Mark Boyd
Sr. Systems Analyst
McBee Associates, Inc.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030425/a3e2411b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 528 bytes
Desc: image001.png
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030425/a3e2411b/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 2302 bytes
Desc: image002.jpg
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030425/a3e2411b/attachment.jpg>