[dba-SQLServer]SQL Import Spec

Mark Boyd MarkBoyd at McBeeAssociates.com
Fri Apr 25 14:57:57 CDT 2003


Francisco -
I'm not real familiar with DTS.  I've used it to import and export
objects, but I can't find a way to save an import spec, in order to use
again.  Is there a way to do this?

Mark

-----Original Message-----
From: Francisco H Tapia [mailto:fhtapia at hotmail.com] 
Sent: Friday, April 25, 2003 3:53 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]SQL Import Spec

Have you looked into using DTS?

-Francisco
http://rcm.netfirms.com

On Friday, April 25, 2003 12:38 PM [GMT-8],
Mark Boyd <MarkBoyd at mcbeeassociates.com> wrote:

: 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.
:
:
:
:
:
:
:
:: _______________________________________________
:: dba-SQLServer mailing list
:: dba-SQLServer at databaseadvisors.com
:: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
:: http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list