FELC Loop through Snapshot Names

Property	Value
Name	FELC Loop through Snapshot Names
Description	Foreach Loop Container
Precedence Executables	none
Contrained Executables	none
ID	4d929d8c-6557-4ec3-b247-4b6ab42a6dc1
Delay Validation	False
Disable	False
Disable Event Handlers	False
Fail Package On Failure	False
Fail Parent On Failure	False
Force Execution Result	Success
Force Execution Value	True
Isolation Level	Serializable
Locale ID	1033
Logging Mode	UseParentSetting
Suspend Required	False
Transaction Option	Supported
ForEachEnumerator.CollectionEnumerator	True
ForEachEnumerator.CreationName	Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.ForEachADOEnumerator, Microsoft.SqlServer.ForEachADOEnumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
ForEachEnumerator.DataObjectVariable	User::ListOfSnapshots
ForEachEnumerator.Description
ForEachEnumerator.ID	{8D6509A7-326F-494A-892E-4937678FBF23}
ForEachEnumerator.Name	{8D6509A7-326F-494A-892E-4937678FBF23}
ForEachEnumerator.Type	2
ForEachEnumerator.VariableMappings	0 , User::NameOfSnapshotToDelete
ForEachEnumerator.Version	0

Name	Type	Description
SCR Concatenate List of DROP Snapshot Failures	ScriptTask	Script Task
SQL Drop Snapshot of DWStaging	Task	Execute SQL Task

Name	Value	Description
User::SnapshotDatabase_DROP	Expression: "DROP DATABASE [" + @[User::NameOfSnapshotToDelete] + "]" DROP DATABASE []
User::SnapshotDatabase_DROP	Expression: "DROP DATABASE [" + @[User::NameOfSnapshotToDelete] + "]" DROP DATABASE []	This is the SQL statement to drop the Snapshot.