Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTS import text file
Message
From
06/07/2005 15:28:17
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01029651
Message ID:
01029669
Views:
12
>I'm trying to import data from a huge text file (20G) on a development server with limited disk space and am having problems running out of disk space. I have enough room for the database itself but I believe I'm having problems due to log file growth as data is being imported.
>
>Is there a way to disable logging during import in DTS? TIA.

John,

Try setting the recovery model on the database to 'bulk logged'. AFAIK, this is the same as full logging, except when performing BULK INSERT operations. Check out 'Bulk-Logged Recovery model' in BOL.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform