Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkiranvr
Yak Posting Veteran
54 Posts |
 Posted - 2008-07-17 : 17:37:17
|
| Here my scenario is, I am calling a file from a directory, so i have given the path into a variable and executing............While i am executing Forr Each Loop container i am getting the below error, can any one help me out with the solution? TITLE: Package Validation Error------------------------------Package Validation Error------------------------------ADDITIONAL INFORMATION:Error at Foreach Loop Container: The result of the expression "@variable" on property "ForEachEnumerator" cannot be written to the property. The expression was evaluated, but cannot be set on the property. (Microsoft.DataTransformationServices.VsIntegration)------------------------------BUTTONS:OK-------------------------------Thanks N Regards,Chinna. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-18 : 05:40:04
|
| whats is @variable? Is it a declared variable in SSIS? |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-18 : 08:10:47
|
| Check that the variable name in SSIS->Variables matches the name of the variable you have mapped in the Foreach Loop editor -> Variable Mapping area. And check that this variable has a value at run-time using the debugger. |
|
|
|
kkiranvr
Yak Posting Veteran
54 Posts |
Posted - 2008-07-18 : 14:16:54
|
| Thanks everyone, at last i have solved with the problem,-Thanks N Regards,Chinna. |
|
|
|
|
|
|
ForEachLoop Container