Using checkpoints in a Foreach Loop Container

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Using checkpoints in a Foreach Loop Container...

Using checkpoints in a Foreach Loop Container

Rate Topic

Display Mode

Topic Options

Author

Message

gosteen

Posted Wednesday, February 20, 2008 12:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 04, 2008 12:50 PM
Points: 1, Visits: 5

Hello All,
I have a Foreach Loop Container setup with the following
Enumerator: Foreach NodeList Enumerator
DocumentSource: file Connection pointing to xml file
Enumeration Type:ElementCollection
OuterXPathStringSourcteType:Direct Input
OuterXPathString: /files/file
InnerElementType: NodeText
InnerXPathStringSourceType: DirectInput
InnerXPathString: ./@*

Variable Mappings
Variable: User:LoopSource Index: 0
Variable: User:LoopDest Index: 1

The 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?

Post #458167

« Prev Topic | Next Topic »

Permissions