x

MS SQL Server 2008 SSIS-Slow speed while importing flat file

Hi,
I am using SQL Server 2008. When I imported flat file (14,204,484 files) to sql database through SSIS package it took almost 75 mins to complete. Could you please let me know why this much long time will take to import flat file.
Thanks in Advance.
Regards,
SQLUSER

more ▼

asked May 25, 2010 at 10:57 AM in Default

pavinm gravatar image

pavinm
5 1 1 1

do you mean 14,204,484 files or ROWS ?
May 25, 2010 at 11:07 AM Fatherjack ♦♦
I thought he means ROWS...
May 25, 2010 at 11:14 AM Leo
One would hope - if it's files, then I can see why it's slow...
May 25, 2010 at 11:28 AM Matt Whitfield ♦♦
14,204,484 rows and each rows contain one document information.
May 26, 2010 at 04:31 AM pavinm
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It depends where you import into. Are you imported into New Table? or Table which is already exists with row identity?

It takes 20 mins to transfer my monthly records (7,000,000) using SSIS in SQL 2008.

more ▼

answered May 25, 2010 at 11:12 AM

Leo gravatar image

Leo
1.6k 54 56 58

I am importing to alreday exists table and i am using data flow to import the file.
May 26, 2010 at 04:32 AM pavinm
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x939
x126
x66

asked: May 25, 2010 at 10:57 AM

Seen: 2242 times

Last Updated: May 25, 2010 at 11:06 AM