Solved

filepath Not available in sql server2012

Posted on 2014-03-04
5
376 Views
Last Modified: 2014-03-05
hello
User FilePath variable is not in the list of values for Expression

This is in reference to this question
http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28380353.html

Please help
0
Comment
Question by:Rayne
  • 4
5 Comments
 

Author Comment

by:Rayne
Comment Utility
I can’t see the user file path as one of the options for system variables – am I missing anything or this is changed for 2012?
0
 

Author Comment

by:Rayne
Comment Utility
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.DataTransformationServices.Controls)
0
 
LVL 9

Accepted Solution

by:
Sreedhar Vengala earned 500 total points
Comment Utility
What is the scope of the "User::FilePath", is it at component level or package level.  If is at package level then it can be accessed from all the components within the package.  If it is at component level then can be accessed only within that component.
0
 

Author Comment

by:Rayne
Comment Utility
Here is the dtsx text on notepad
Package-dtsx.txt
0
 

Author Comment

by:Rayne
Comment Utility
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
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now