dbTalk Databases Forums  

Setting up the Commit option on SSIS

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts Setting up the Commit option on SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Setting up the Commit option on SSIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
CarlosR
 
Posts: n/a

Default Setting up the Commit option on SSIS - 12-08-2005 , 01:35 PM





I'm having problem on SSIS because I dont know how to specify how much
records it will commit.

The package that I'm running is working with about 2 million records
and the database doesnt have enough memory to work with all those data
(actually my server has 4GB of memory).

I need to specify it to save each 10k records, for example. Is there
any way to do that?

Tks


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top