Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS non-LOGGED operations ??

Status
Not open for further replies.
btturner

btturner

Programmer
May 17, 2001
175
US
On SQL 2k, How can I set my DTS package, which imports a 3 million row .TXT file to a table, as a NON-LOGGED operation?

(LOGGING is taking tooooo long!! I will be sure to run a full DB backup when the job completes.)

thx-
BT
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

bmacbmac
  • Locked
  • Question
Help with RegEx to find non alphanumeric characters
Replies
1
Views
2K
ggriffit
ggriffit
BxWill
  • Locked
  • Question
Create Non-XML Format File for Bulk Insert - Error: Could not open connection to Sql Server 1
Replies
1
Views
314
fredericofonseca
fredericofonseca
Cobby1812
  • Locked
  • Question
Create a Row of Data on Non Business Day
Replies
4
Views
238
TamarGranor
TamarGranor
dwg23
  • Locked
  • Question
Query fails with error of "An expression of non-boolean type specified in a context
Replies
6
Views
481
dwg23
dwg23
BrooksMT
  • Locked
  • Question
Need a little help with non aggregate Pivot table
Replies
1
Views
128
BrooksMT
BrooksMT

Part and Inventory Search

Sponsor

Back
Top