Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Using checkpoints in a Foreach Loop Container Expand / Collapse
Posted Wednesday, February 20, 2008 12:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 4, 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 »

Add to briefcase

Permissions Expand / Collapse