Huge Imports using DTS - advice needed ...

[Manu]

Hello Specialists !

Please help me - i need advice in importing textual data to SQL Server.

I am using DTS with a simple process : Text(source)->Connection.
I want to increase speed of importing because i have to import 4GB (1000
char lines lenght) of data.

Do you have any tips for me ?
Best regards,
Manu

[Dan Guzman]

The fastest way to import data with DTS is with minimally-logged operation.
This requires that the target database be in the SIMPLE or BULK_LOGGED
recovery model and have no indexes (including primary key and unique
constraints).

In your Transform Data task property options, check the 'use fast load' and
'table lock' boxes. Specify an fairly large insert batch size such as
50000. After the import, recreate you constraints and indexes.

See the Books Online <optimsql.chm::/odp_tun_1a_5gyt.htm> for more
information on optimizing bulk copy performance.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Manu" <pa**********@wp.pl> wrote in message
news:cd**********@achot.icm.edu.pl...

Hello Specialists !

Please help me - i need advice in importing textual data to SQL Server.

I am using DTS with a simple process : Text(source)->Connection.
I want to increase speed of importing because i have to import 4GB (1000
char lines lenght) of data.

Do you have any tips for me ?
Best regards,
Manu