Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question of the Day for 22 Feb 2006 Expand / Collapse
Author
Message
Posted Tuesday, February 14, 2006 4:05 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the Question of the Day for 22 Feb 2006 posted at http://www.sqlservercentral.com/testcenter/qod.asp?QuestionID=715.
Post #258431
Posted Wednesday, February 22, 2006 9:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 15, 2008 12:02 PM
Points: 1,318, Visits: 57

C or B should be considered correct. By setting the batch size to 1 (B) you are setting the transform to commit after each row(C).

Both interpretations rely on the transform NOT being part of a larger transaction which may affect final commit.

Terry




Post #260672
Posted Wednesday, February 22, 2006 10:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 13, 2008 12:04 PM
Points: 171, Visits: 30
According to the Help file Check  Always commit final batch
Always commit final batch
Select to commit all rows in the final batch that were processed successfully before an error occurs. This property applies when a transformation or insert error occurs during processing of the final batch, so that all rows in the batch prior to the error do not have to be processed again. The setting is useful for large batch sizes. This option is available only if you enable Use fast load.
Post #260681
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse