Merry Ho Ho
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: PurpleKush
To: SQL
Sent: Monday, December 22, 2003 3:15 PM
Subject: Re: DTS package
How do I get off this list??????
[EMAIL PROTECTED] wrote:David,
Unless you need to transform the data as you import it, you will
probably have better luck with a bulk insert. Use bcp to create a format
file that you can use with the bulk insert operation. You can run your
tests with bcp to make sure it will do the job, then script it out in
query analyzer.
Thanks,
Eric
"David Brown" <[EMAIL PROTECTED]>
12/19/2003 11:02 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: DTS package
I have a pipe delimited text file (17 columns) with LF as the row
delimiter. One of the files that I need to import is over 56 megs. I
have tried DTS to import the file, but get around 1000 rows per second.
Is bulk copy the best or just straight import through a dts package?
I am looking for the fastest way to import it. After 4 min I had 86000
rows out of about a million.
David
---------------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
