Rayne
asked on
filepath Not available in sql server2012
hello
User FilePath variable is not in the list of values for Expression
This is in reference to this question
https://www.experts-exchange.com/questions/28380353/ssis-import-magic.html
Please help
User FilePath variable is not in the list of values for Expression
This is in reference to this question
https://www.experts-exchange.com/questions/28380353/ssis-import-magic.html
Please help
ASKER
When i manually type in the filepath I get this
Expression cannot be evaluated.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&ProdVer=10.0.40219.1&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476
-------------------------- ----
ADDITIONAL INFORMATION:
The variable "User::FilePath" was not found in the Variables collection. The variable might not exist in the correct scope.
Attempt to parse the expression "@[User::FilePath]" failed and returned error code 0xC00470A6. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.
(Microsoft.DataTransformat ionService s.Controls )
Expression cannot be evaluated.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202010&ProdVer=10.0.40219.1&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=FailToEvaluateExpression&LinkId=20476
--------------------------
ADDITIONAL INFORMATION:
The variable "User::FilePath" was not found in the Variables collection. The variable might not exist in the correct scope.
Attempt to parse the expression "@[User::FilePath]" failed and returned error code 0xC00470A6. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.
(Microsoft.DataTransformat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is the dtsx text on notepad
Package-dtsx.txt
Package-dtsx.txt
ASKER
Looks like we all need to know how to first create user variables and then reference them in our for each container - that rings the bell
Usefull Link to consider for starters
http://www.youtube.com/watch?v=MT9_jcSDNfY
once the user variables are set up, then all else happens
Usefull Link to consider for starters
http://www.youtube.com/watch?v=MT9_jcSDNfY
once the user variables are set up, then all else happens
ASKER