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

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.

more ▼

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

avatar image

5 1 1 2

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

avatar image

1.6k 55 59 62

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: May 25, 2010 at 10:57 AM

Seen: 2522 times

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

Copyright 2018 Redgate Software. Privacy Policy