x

login about faq Site discussion (meta-askssc)

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

0

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

asked May 25 '10 at 10:57 AM in Default

pavinm
5 ● 1 ● 1 ● 1

do you mean 14,204,484 files or ROWS ?

May 25 '10 at 11:07 AM Fatherjack ♦♦

I thought he means ROWS...

May 25 '10 at 11:14 AM Leo

One would hope - if it's files, then I can see why it's slow...

May 25 '10 at 11:28 AM Matt Whitfield ♦♦

14,204,484 rows and each rows contain one document information.

May 26 '10 at 04:31 AM pavinm

(comments are locked)

1 answer:

0

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.

answered May 25 '10 at 11:12 AM

Leo
1.6k ● 48 ● 54 ● 58

I am importing to alreday exists table and i am using data flow to import the file.

May 26 '10 at 04:32 AM pavinm

(comments are locked)

Your answer

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

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

ssis x750
administration x119
import-data x58

asked: May 25 '10 at 10:57 AM

Seen: 1489 times

Last Updated: May 25 '10 at 11:06 AM

Related Questions

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.