 | |
Re: Data Driven Query vs commit
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Data Driven Query vs commit -
06-23-2004
, 03:32 PM
|
I can't write an insert commit size to a data driven query. The commit is done at the end? Can i do a commit at each 1000 row? I see a problem because my DTS do 3 000 000 insert in the BD. If it do the commit at the end, my transaction log wil grow grow grow! |
#2
| |||
| |||
|
|
Which page? The fetch size have influence with the memory, not the transaction log? "Allan Mitchell" wrote: According to this page the DDQ can be configured to commit immediately. mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts sql.chm::/dts_usage_6xet.htm Have you tried playing with the FETCH size? Allan -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Bernard" <Bernard (AT) discussions (DOT) microsoft.com> wrote in message news:3A5D77F3-7A6A-4A6D-8095-47BD87999528 (AT) microsoft (DOT) com... I can't write an insert commit size to a data driven query. The commit is done at the end? Can i do a commit at each 1000 row? I see a problem because my DTS do 3 000 000 insert in the BD. If it do the commit at the end, my transaction log wil grow grow grow! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.