SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services / Using checkpoints in a Foreach Loop Container / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:51:41 GMT20Using checkpoints in a Foreach Loop Containerhttp://www.sqlservercentral.com/Forums/Topic458167-148-1.aspxHello All,I have a Foreach Loop Container setup with the followingEnumerator: Foreach NodeList EnumeratorDocumentSource: file Connection pointing to xml fileEnumeration Type:ElementCollectionOuterXPathStringSourcteType:Direct InputOuterXPathString: /files/fileInnerElementType: NodeTextInnerXPathStringSourceType: DirectInputInnerXPathString: ./@*Variable MappingsVariable: User:LoopSource Index: 0Variable: User:LoopDest Index: 1The container loops through the entries in a xml assigning a sourch and destination variable used in a custome tranfer component. I am transferring tables from our proprietary database to SQL Server.Now for the Question:If I set up checkpointing on the Foreach Loop Container and 30 tables are tranferred with the 31 having an issue. When it restarts will it actually start from the 31 entry?Wed, 20 Feb 2008 12:17:51 GMTgosteen